{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sqlalchemy\n",
    "import pandas as pd\n",
    "import datetime\n",
    "import random"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sqlalchemy import create_engine\n",
    "conn = create_engine('mysql+pymysql://root:123456@localhost:3306/recommend2?charset=utf8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "current_day = '2020-07-01'\n",
    "last_day = '2020-06-29'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>customer_id</th>\n",
       "      <th>tel</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3463</td>\n",
       "      <td>dbcbd87b4684a6af53f0112c6020437a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3464</td>\n",
       "      <td>bd0a35534cfca505a9825a4c9bd05ea4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3465</td>\n",
       "      <td>23d6673202f138dde2725b8e7947254c</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3466</td>\n",
       "      <td>98e9f6a0a2c8ad8fa7beca18ed1b9909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3467</td>\n",
       "      <td>9f1b05f0d92ed6002be01da916690710</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   customer_id                               tel\n",
       "0         3463  dbcbd87b4684a6af53f0112c6020437a\n",
       "1         3464  bd0a35534cfca505a9825a4c9bd05ea4\n",
       "2         3465  23d6673202f138dde2725b8e7947254c\n",
       "3         3466  98e9f6a0a2c8ad8fa7beca18ed1b9909\n",
       "4         3467  9f1b05f0d92ed6002be01da916690710"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sql1 = 'select id as customer_id,tel from customer where id not in (select customer_id from mission group by customer_id);'\n",
    "df_customer = pd.read_sql(\n",
    "    sql1,conn\n",
    ")\n",
    "df_customer.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[2,\n",
       " 30,\n",
       " 14,\n",
       " 23,\n",
       " 16,\n",
       " 3,\n",
       " 25,\n",
       " 12,\n",
       " 28,\n",
       " 22,\n",
       " 29,\n",
       " 8,\n",
       " 19,\n",
       " 26,\n",
       " 21,\n",
       " 24,\n",
       " 27,\n",
       " 11,\n",
       " 6,\n",
       " 13,\n",
       " 15,\n",
       " 4,\n",
       " 18,\n",
       " 17,\n",
       " 20,\n",
       " 1,\n",
       " 5,\n",
       " 7,\n",
       " 10,\n",
       " 9]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sql2 = 'select id from salesstaff;'\n",
    "df_salesstaff = pd.read_sql(\n",
    "    sql2,conn\n",
    ")\n",
    "salesstaff_ids = df_salesstaff['id'].values.tolist()\n",
    "salesstaff_ids"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'salesstaff_id': 2,\n",
       "  'customer_id': 3463,\n",
       "  'tel': 'dbcbd87b4684a6af53f0112c6020437a'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3464,\n",
       "  'tel': 'bd0a35534cfca505a9825a4c9bd05ea4'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3465,\n",
       "  'tel': '23d6673202f138dde2725b8e7947254c'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3466,\n",
       "  'tel': '98e9f6a0a2c8ad8fa7beca18ed1b9909'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3467,\n",
       "  'tel': '9f1b05f0d92ed6002be01da916690710'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3468,\n",
       "  'tel': 'c6f946c946ec538594bed631597e9b61'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3469,\n",
       "  'tel': '424708ac1303a4d4e10f4bb4ffdeb988'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3470,\n",
       "  'tel': 'a63e27f4ebda0bee6f2d5ed8c3e0746e'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3471,\n",
       "  'tel': '3c0c476bc346b900ef0bd1b0da4734d5'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3472,\n",
       "  'tel': '36d233d1c60f650f6aad498dfc9778f7'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3473,\n",
       "  'tel': 'c64d56cf3420e3afab7c66dfabcf7731'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3474,\n",
       "  'tel': '9a92d6526403c7674e8c0d9c009b3112'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3475,\n",
       "  'tel': 'a49eb79ecf61d6a7b1db3919236f5b8b'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3476,\n",
       "  'tel': '92ec57f96f508db7c7f70dbc49bc8196'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3477,\n",
       "  'tel': 'f2efa362b6d20d5ca8575bcc7e7d7bf3'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3478,\n",
       "  'tel': '67d51008ae6d1e6220058a91dd9b1df0'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3479,\n",
       "  'tel': '02f5d585af06c2d51fe49c4924dd7f0a'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3480,\n",
       "  'tel': '53fb3ff030fcc18e5433d7dd4c287968'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3481,\n",
       "  'tel': '4e56b48f518faa137481b25a263069f0'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3482,\n",
       "  'tel': '67dfd3405f9e34df3b8e1879d816cf63'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3483,\n",
       "  'tel': 'd8e1f82fcc15098574d01e5812cc14f6'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3484,\n",
       "  'tel': '1fa67c08853d36be37f30d51c7553bdf'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3485,\n",
       "  'tel': 'f113ddb2286d8c898596cd9a2e499950'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3486,\n",
       "  'tel': 'b83dc1b86d9f1bef46609654859506d1'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 3487,\n",
       "  'tel': '43724f1ad0dfc7cbe9147017c04aa716'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3488,\n",
       "  'tel': '40fed69b08bd2b5905fe6cd5e608f798'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3489,\n",
       "  'tel': '78983df2255feae0249bf543dafd5656'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3490,\n",
       "  'tel': '98cf5b256fcb5079f7d3c8092f841063'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3491,\n",
       "  'tel': '82bbb6d816f4df00d3cdbaa9a257fd55'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3492,\n",
       "  'tel': '302c30382a6589dc1a217d3fe6bd1cee'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3493,\n",
       "  'tel': '1b2325536a08cee4f247789a8ed4937d'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3494,\n",
       "  'tel': '677f712d45af94ebe0dc0bd7574df9d0'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3495,\n",
       "  'tel': '2df0059f44cd278c2f517bf8acb8a24f'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3496,\n",
       "  'tel': '88377db0baea402eaabf2beb6651bf86'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3497,\n",
       "  'tel': '94ebe45864b0af6ba49f05c8410f1cef'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3498,\n",
       "  'tel': '49368361e6ef9b52c7749f2023f9fce9'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3499,\n",
       "  'tel': '7a5ad18be4a7f29557aeab82db0b386a'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3500,\n",
       "  'tel': '0f1babcbe7e2f4765303b46a9e29329b'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3501,\n",
       "  'tel': '739579a869d723301408ab3f00de776d'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3502,\n",
       "  'tel': 'e726628dd777fafc8f5e124325dc04a2'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3503,\n",
       "  'tel': 'ce8e1e2b0a3968f0461d4a4451f40240'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3504,\n",
       "  'tel': 'c53fcd9b9158da2bcf72e3ccecf22107'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3505,\n",
       "  'tel': 'd083ae95bc6de495d9abe96273c87dee'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3506,\n",
       "  'tel': '906a8ddc103769d36d32cecebb588705'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3507,\n",
       "  'tel': '3fe6909c38012b5831b7bdf62a6e5d96'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3508,\n",
       "  'tel': 'ee019544396a3c274ad68e33fd461b2d'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3509,\n",
       "  'tel': '0a0682bb4ec75dc5d1e5bb3f1bdc472d'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3510,\n",
       "  'tel': '7864d45f1e2632e295784c3848ef44cf'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3511,\n",
       "  'tel': '282583f0109c75c84f62cba77e2a0433'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 3512,\n",
       "  'tel': '2c12d074290f70a751fd30232b1bbc4a'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3513,\n",
       "  'tel': '5c1d21fe21a38950d5791ebe94e366ba'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3514,\n",
       "  'tel': 'bba9dd16aaf7fb23c166fab3bde1b6dd'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3515,\n",
       "  'tel': 'e3a8f33ff7d8a397c0f93d08d14f2a28'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3516,\n",
       "  'tel': '0c47e83cf62cba02c89b4ae08b00cc04'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3517,\n",
       "  'tel': '8c9db5b89f3e7db83dacf75a9fda1009'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3518,\n",
       "  'tel': '5493217734785056f68e2f7bb66c7611'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3519,\n",
       "  'tel': '0137e86c6b9c042c6abb43a07d30de10'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3520,\n",
       "  'tel': 'ab36d04ef8d2da9945ddf1b04a8cb92d'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3521,\n",
       "  'tel': '96b4cefd8badc1808d322b65af3f3482'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3522,\n",
       "  'tel': '9d281c70ec4f157a98ea49b880b40148'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3523,\n",
       "  'tel': '7524b028702da2ae3903a689ed13d223'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3524,\n",
       "  'tel': 'b5794f545333db7b5234de691f5055b7'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3525,\n",
       "  'tel': '8737e353734b928f442c9d940ebd38b8'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3526,\n",
       "  'tel': 'f711ad64ea6d78d55719a84903caa33b'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3527,\n",
       "  'tel': '7e0e3be27c0869008790fd6d440d659c'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3528,\n",
       "  'tel': '43e6e5ffdf3accaad1bbc77113653ea3'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3529,\n",
       "  'tel': '4750541a685a3d311dfe7f1e5de4031d'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3530,\n",
       "  'tel': '058bc07d896d356c13657f97deb45911'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3531,\n",
       "  'tel': '9160180484834ba8a1122e92b85c11de'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3532,\n",
       "  'tel': 'ec1471aec199e61e7a3af1d63d79eb69'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3533,\n",
       "  'tel': 'f229d83bae2aabdf68d4d3a51ed5c41e'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3534,\n",
       "  'tel': '2b3256903c0f20a5b2ff02ae64e45ab5'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3535,\n",
       "  'tel': 'ec23a283f8d1c311e1853ddf7680d102'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3536,\n",
       "  'tel': '7fec1c4e2f5f2101c25d2509cdee8564'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 3537,\n",
       "  'tel': '785c55951d944eabcba12ebc57bd0054'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3538,\n",
       "  'tel': 'bdb33d0d7a9b4d3f190c4ee07c12f1b4'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3539,\n",
       "  'tel': '1bb1f16e9a51e428f660f411694d3929'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3540,\n",
       "  'tel': '33bf34736ac611a7458fdde8dbd3cb4c'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3541,\n",
       "  'tel': 'c8e5ff4063f16806304a4482a096baba'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3542,\n",
       "  'tel': 'df4d01a6c33b2b134ea8b14729dbd605'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3543,\n",
       "  'tel': 'b204f3fa578cf36751b178095b9286ab'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3544,\n",
       "  'tel': '1c8c29285900785fd9ae9c1461e3aa97'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3545,\n",
       "  'tel': 'bba2f0c7058a4470018e398a30786c5a'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3546,\n",
       "  'tel': '72d7d51db21cc42edadc3e155f4b09d6'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3547,\n",
       "  'tel': '60075dbc322ab0ced0853a9344154cf9'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3548,\n",
       "  'tel': '52adb34d312b6eb5a1b24bec39cf0ff0'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3549,\n",
       "  'tel': 'f9ec4d7f3808dc159a89513a5675de7b'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3550,\n",
       "  'tel': 'f108809b2ca6935ccb0f06085dc3b520'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3551,\n",
       "  'tel': '1e9e496655b2d6f96e1429e4e2f9710f'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3552,\n",
       "  'tel': '4ab0c9fd9255d7159abed5332d7d9097'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3553,\n",
       "  'tel': '258c786f40f72b741a6a54756378c5d7'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3554,\n",
       "  'tel': 'f97283e33b4d0c3b2a582ef2ad8a6e3f'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3555,\n",
       "  'tel': '8b2e6bf03f7cc9cfa30bc33f33884a22'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3556,\n",
       "  'tel': '78e23bb3d9e86536d7e2801c3af5efee'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3557,\n",
       "  'tel': '37c2fd9712ae0e4a0fc358d9102340e0'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3558,\n",
       "  'tel': '0627eed3ff7e005ef4b20c6b0948f341'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3559,\n",
       "  'tel': '1e8b526607393216c5a1468675ee301f'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3560,\n",
       "  'tel': 'b47db3b73fcf9d87edddd2c8dfb41d04'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3561,\n",
       "  'tel': '437e39ebaf3a3bdb862ee4890cf97e45'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 3562,\n",
       "  'tel': 'c95bb861079cc1173bc8f991c6f3eab6'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3563,\n",
       "  'tel': '1f7b93c6fa584f19e46036a22acba2dd'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3564,\n",
       "  'tel': 'b934fe873ace1a1bcc95f3eae3408df2'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3565,\n",
       "  'tel': 'c69fe68a510d4f001b5dea3590509fe7'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3566,\n",
       "  'tel': 'e3b2b7484c93eba62f46541e064ea0bf'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3567,\n",
       "  'tel': 'ec4418c6f113ceb708f412f91f50aabc'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3568,\n",
       "  'tel': 'aa51d9f9a2c1c4256bc28ffcbb5ff4aa'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3569,\n",
       "  'tel': '7ba14de6b0cf4797f34ef166c3c3467a'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3570,\n",
       "  'tel': '71f45e0dcaf8ae5fafef321adfb22172'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3571,\n",
       "  'tel': 'ca547c279cbde3faff7c8d694e656787'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3572,\n",
       "  'tel': '0595eb9acb39440b07a4371361df1b6d'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3573,\n",
       "  'tel': '6e904bbad9f01cc65d13f3a07b60f1d8'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3574,\n",
       "  'tel': '00b21d7adbde94854432f69351926cf9'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3575,\n",
       "  'tel': '0b42cfae0234c62d30412538135395f9'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3576,\n",
       "  'tel': 'a08cbc4410434175572e647050ab09f7'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3577,\n",
       "  'tel': 'c4dc0f8059eaffde1f7e6f72be3cf239'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3578,\n",
       "  'tel': '7f71a61f3053dcd2cb5e054c06ce2c0d'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3579,\n",
       "  'tel': 'effd07ae3d667099d5b0557838087679'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3580,\n",
       "  'tel': '2f8975caf660449d0ff5bc087e356aab'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3581,\n",
       "  'tel': '3720117f3c36572dea81b1c17265d3af'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3582,\n",
       "  'tel': 'e052c5e26e26477ab47dd4ab0b21d0d5'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3583,\n",
       "  'tel': '327b4b793d4094e85dda4116a130b347'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3584,\n",
       "  'tel': 'ea3d37ea002d8efbf5efb59fc1d8bab3'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3585,\n",
       "  'tel': 'adbe9b27861217ca13a7c87e2af09663'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3586,\n",
       "  'tel': '738e4bbfd4c65e7d2894b5cfc1b94c9d'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 3587,\n",
       "  'tel': 'bc89807b14775dcac42e3be9f787b74f'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3588,\n",
       "  'tel': '8a6b53e3c0deac04488e61ab9f2936db'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3589,\n",
       "  'tel': '163714e1338c4d16600c72ca654e9a15'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3590,\n",
       "  'tel': '96a18d7960756da995206a3bdbaa6680'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3591,\n",
       "  'tel': '0fecaa19857698b306cb9b4489a3cfb9'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3592,\n",
       "  'tel': 'a1a6bb605af70fc50e9f5f7d2c72174f'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3593,\n",
       "  'tel': '2fcb58100c9f2824c4d5ca1ff6a08269'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3594,\n",
       "  'tel': 'cfbf0454e6bf452d67d159cb3a7e3c97'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3595,\n",
       "  'tel': 'c508b481b34d6a0231ed06679631f647'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3596,\n",
       "  'tel': 'c38c18f4ce78203e9b785b34112cf83a'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3597,\n",
       "  'tel': 'c431d9b226a018af5c1f1ade7ce2dba6'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3598,\n",
       "  'tel': '48135b03235fbfe20ccadda5a29aebab'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3599,\n",
       "  'tel': '2aef975d4e2b16028f3e14d4c1b86035'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3600,\n",
       "  'tel': '20b3ae61a50109cafdb65c350c12e5dc'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3601,\n",
       "  'tel': '8b995558228a78aa2fe57cab30d090ed'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3602,\n",
       "  'tel': 'c5a0b84f89809984774a4b318e7f8a2f'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3603,\n",
       "  'tel': '1505276a29612339fbc8e2eee0affb85'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3604,\n",
       "  'tel': 'bfe4ab80bbe6d75cd764504b3639d9e3'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3605,\n",
       "  'tel': '61b259736c7d64c435f981432a162047'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3606,\n",
       "  'tel': 'b74ba895c9b54e09f3e0e9dcf0f8c222'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3607,\n",
       "  'tel': '665ed4ee7222b59178d2654d5435988a'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3608,\n",
       "  'tel': '9c701f06a3ba2f1cf6d23ed8c62db038'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3609,\n",
       "  'tel': '6478e518b32e10ba3e14b39fdf6372a5'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3610,\n",
       "  'tel': 'b53ea8bfd435dbac8a93d2fdb3b73c46'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3611,\n",
       "  'tel': '6091adebf54fb85af3e9b5605bd8ce1c'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3612,\n",
       "  'tel': '8de33a331c63f0ef43e285529c303ee9'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3613,\n",
       "  'tel': '30ca12428e145a71366f060bb908f1f9'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3614,\n",
       "  'tel': 'e89fb5232fdc910e20bab9be48f04144'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3615,\n",
       "  'tel': 'aec4d38bb4bd6af1892a9251119953cf'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3616,\n",
       "  'tel': 'f0f2999431566fa4cc12bfb9f251ea1a'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3617,\n",
       "  'tel': '9ff44c1d06239f7ac4a9dcc9a0438e0a'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3618,\n",
       "  'tel': '20c83b622b7346b93a70af0f103ccf00'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3619,\n",
       "  'tel': '23d9a8d38468196c3496f2fc2664075a'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3620,\n",
       "  'tel': '5a30ad6d4fe402495f79b5475c13d652'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3621,\n",
       "  'tel': 'f33ffa49fd0905b7e100fc116b5a48ca'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3622,\n",
       "  'tel': '373a32321e2abd94cb462e50d658652f'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3623,\n",
       "  'tel': 'd1aeb6edf65352e21c3c8a3da0323598'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3624,\n",
       "  'tel': '605739bd2eeaf8656a7c31e931a180a9'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3625,\n",
       "  'tel': '5812ad49b8fa6c9d52127ff25abdadaa'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3626,\n",
       "  'tel': '818290db4169f39e84eb370ad3a1b5bd'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3627,\n",
       "  'tel': 'a9ac7377d3a71f66644df0e6339e9f1e'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3628,\n",
       "  'tel': '06a9aa38863186a905fd49ed5f9ad856'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3629,\n",
       "  'tel': '75bf27f71dd0a66c943ed5c8b19f14c6'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3630,\n",
       "  'tel': '5e49a8e06dffcc760c7f4a85cf1cefce'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3631,\n",
       "  'tel': 'a14f43ec4c0e9c32c606ac2d0daa0531'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3632,\n",
       "  'tel': '8dc2e979ea0582403059a4b09ce4d825'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3633,\n",
       "  'tel': '1313a0a26c10d3a13ab9eaa4c9f8d2ce'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3634,\n",
       "  'tel': '08ae09aca50b707d49bbbe52f0f2ce3e'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3635,\n",
       "  'tel': '7df686eb7b34b79faceddefce4d02fe5'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3636,\n",
       "  'tel': 'a35b2e759c9deb3efd93c83001a119bf'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 3637,\n",
       "  'tel': '7661f2522ef8f9e02bef5b925d8a35e3'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3638,\n",
       "  'tel': '93b0b0598a877b90ed09d3499a1a7dfc'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3639,\n",
       "  'tel': 'e3e62c102c911133bb71cb347df3617d'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3640,\n",
       "  'tel': 'ddd41487c2f0bf2ee3162f2e0d74ecb7'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3641,\n",
       "  'tel': '9d87915f9c613b16deccc1b56b5377aa'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3642,\n",
       "  'tel': 'bfff344f22fa17ab36c4ed11370448ab'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3643,\n",
       "  'tel': 'bdf198801ab279d682311ec676eecab7'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3644,\n",
       "  'tel': '9d8fc65299a4703cbea84411c23a338a'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3645,\n",
       "  'tel': 'ef52dba4cac0d1ff873d5ea67b11f7f7'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3646,\n",
       "  'tel': '4d1fd00fd57e62ecc0b166d4c2ef1fa9'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3647,\n",
       "  'tel': 'd324455b7f32575286f9506408956da3'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3648,\n",
       "  'tel': 'd59bfc01e1aac62e09bd50316df86ab5'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3649,\n",
       "  'tel': 'b98f8dd37723c9b2451c3b4909854003'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3650,\n",
       "  'tel': 'd117e4ffbd3ba047a47d9a29339d5e46'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3651,\n",
       "  'tel': '1226ef75d7e94acdd957137eaade9453'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3652,\n",
       "  'tel': '0452b443537672aec3c745037a0a7be5'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3653,\n",
       "  'tel': '72a78b0d6ffaf62ff229e6e855158cd8'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3654,\n",
       "  'tel': '77f33437bbd46501545749d9503e8584'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3655,\n",
       "  'tel': '882a6783dbf2a166d62d975f0c12945c'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3656,\n",
       "  'tel': '85aa1803c05656e363d53ff884382bd5'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3657,\n",
       "  'tel': '92b57c31fc2e3e28657192140e3485e6'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3658,\n",
       "  'tel': '84970eb047aa685bc9714adff175a577'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3659,\n",
       "  'tel': '7620bf4268fd9abccb81c344fd9e2bd5'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3660,\n",
       "  'tel': 'f0b0c71ca29953e4c5ac332bb533dcd2'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3661,\n",
       "  'tel': '77962296a01de11f82aafc8bc56a4882'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 3662,\n",
       "  'tel': 'c6308c7fe62bb897517b199b08088528'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 3663,\n",
       "  'tel': '9e4d5e1c5f70d0cd6fdb9ee51ba7c7b6'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 3664,\n",
       "  'tel': 'bf965d0f3759f4af6361e1bfcb8cab99'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 3665,\n",
       "  'tel': '38f6ec2460f7cbea16dda287656afadb'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 3666,\n",
       "  'tel': 'd56a0648a06a41908cf1b4c3c5b7d3c4'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 3667,\n",
       "  'tel': '6a4a2bb8212963335276efdb7297ad8b'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 3668,\n",
       "  'tel': 'c60d723cc428aaf974d1028df7333348'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 3669,\n",
       "  'tel': 'bc7dd0ac2da525224f7e4cbfab68c223'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 3670,\n",
       "  'tel': '218e029a14bef5be026cad255516b88a'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4063,\n",
       "  'tel': 'a0cf88384e635b29ee274931d9eca771'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4064,\n",
       "  'tel': 'd982092e2c74b9adeb53b8c3f1e88e20'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4065,\n",
       "  'tel': '9e97ca2507fed81b2d8fed2223aea5f9'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4066,\n",
       "  'tel': 'd6c9a2fec23f7740b92655d4fdcd5420'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4067,\n",
       "  'tel': 'f2646d2060102412d8aef0b98641dafd'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4068,\n",
       "  'tel': 'f76c245b50253d345cfeba834af64c4f'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4069,\n",
       "  'tel': '4e3ac8f522bd8c16e26f23819a701526'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4070,\n",
       "  'tel': '8357a4e81201d384b5f6b951be231848'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4071,\n",
       "  'tel': '20a55d9a9d0597c05502b3df52eb9327'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4072,\n",
       "  'tel': 'a7a2d7d5d4a9c53655803f7d60ea4120'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4073,\n",
       "  'tel': 'faae9754803b2b356f8fa8d5169b7c64'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4074,\n",
       "  'tel': '602ffc7f2cdf0b0326abcbba5130c892'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4075,\n",
       "  'tel': '289cb51467f7902ed82110fe4f223519'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4076,\n",
       "  'tel': '4984cfe6b661facaa1581bb96d6603db'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4077,\n",
       "  'tel': '7a37aacbd9f43098dde7e78449cd8988'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4078,\n",
       "  'tel': 'f176a824a23b4d3c81151f25a1d3d20e'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 4079,\n",
       "  'tel': '6a4338b0209bfba79984565ddb96b905'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4080,\n",
       "  'tel': '09385644dcee64b85c9a42dc259b40e6'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4081,\n",
       "  'tel': 'f74ccf7606df8d86116411f23bfccc3f'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4082,\n",
       "  'tel': '84667d5d024de7ffc2ea2f01def926e8'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4083,\n",
       "  'tel': 'd8821a6571748deeebe807fcfd100bd7'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4084,\n",
       "  'tel': 'f6969a65cab8af2848907364b8ec9f66'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4085,\n",
       "  'tel': 'f12623d6dfe0dc2401e2d9e3c41fbc3e'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4086,\n",
       "  'tel': '1f0a256655f2828a8ccd9d8c4ab85688'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4087,\n",
       "  'tel': '14d0cdbabdf8d76f604659742dd7f79a'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4088,\n",
       "  'tel': 'b11ccf15b0f5c3ec82779be1e870b3a2'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4089,\n",
       "  'tel': 'e696bf50b55c27ceaf69662238cf811d'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4090,\n",
       "  'tel': '4e841e68fd7cf640c173142bd95713a4'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4091,\n",
       "  'tel': 'c73b1956cdf6fa80987fa9a400e5b6dd'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4092,\n",
       "  'tel': 'c3816ee94093c8e6582323c05a4bb76f'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4093,\n",
       "  'tel': 'de5e90a2fc4f5a76dbda511905945632'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4094,\n",
       "  'tel': '7abb26eccacdf2d9b93d33a6b9c5500d'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4095,\n",
       "  'tel': '6220b467a208c3b768362c0e7f9ca5ef'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4096,\n",
       "  'tel': '2ec310e65a0e58f916ea7607d5ef568b'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4097,\n",
       "  'tel': 'eafac1d0224f473152ffc952bc7d7289'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4098,\n",
       "  'tel': '97d861f5ec22ac72ab9eea5ffd4d43aa'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4099,\n",
       "  'tel': '0793e88957f85385ea34e9248944c886'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4100,\n",
       "  'tel': '8fc80978c00b165c60530932ca62c58c'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4101,\n",
       "  'tel': '3e020146106488e329670dbd39e79f9c'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4102,\n",
       "  'tel': '827d9533f3491a2c98efa59b5562db6c'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4103,\n",
       "  'tel': 'ea167257176dcb1f94dd02cab25462b7'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4104,\n",
       "  'tel': '8bc7e459d42755fd28469ab2ab31f553'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4105,\n",
       "  'tel': '3a98c52624ad98756b3fd971ad131e71'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4106,\n",
       "  'tel': '0c88c259258f8bb7c3ece440a802efbf'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4107,\n",
       "  'tel': '5adaa34fe054ef2836966c6b456e1d86'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4108,\n",
       "  'tel': 'b0290a172a10649c19757c0bfaa7a874'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4109,\n",
       "  'tel': '25ad557e4bd51066ee63b829ebac361a'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4110,\n",
       "  'tel': '9bcf03c7bd0cac0bee10d528baf95e0a'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4111,\n",
       "  'tel': 'b9e290ee83cabc8842115654495531a2'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4112,\n",
       "  'tel': 'ff8ed99ad4f60059d48694392068b87b'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4113,\n",
       "  'tel': 'fd0fe9d35d9a3dd9a666f1144286465f'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4114,\n",
       "  'tel': 'fb8030e7c6e18796e318e8444fc53c2b'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4115,\n",
       "  'tel': 'fa825cf2a626f01b2de1057f0cb888a7'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4116,\n",
       "  'tel': 'fa7f22e610fb0d7a1c44316f313fb8c7'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4117,\n",
       "  'tel': 'df42fb05de882ed5df62a07fab671a38'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4118,\n",
       "  'tel': '7f5fc4d5d571b0e35a988173b21f741b'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4119,\n",
       "  'tel': '4bc24d4dfc31a1e4728130a3f050cceb'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4120,\n",
       "  'tel': '4684ea8083fab4ee94422e5e44324607'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4121,\n",
       "  'tel': 'bc41bb0165ea4d4248738f2eeac0c45d'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4122,\n",
       "  'tel': '7a3f17678c57f2740b90ae0df55b73be'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4123,\n",
       "  'tel': 'f08b614579016e54e5b92919f95a5792'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4124,\n",
       "  'tel': '740c0c6aa07eb1c15f52ec686073152d'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4125,\n",
       "  'tel': '8382884454d5ef81501a2607c073facb'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4126,\n",
       "  'tel': '27eb01ea05bf8bd0a799bf0fb2171e08'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4127,\n",
       "  'tel': 'd4c4f75f6c256ac116c13ec1947a3bcf'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4128,\n",
       "  'tel': '0c8a39efbf3c93296fd4a6c93763f135'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 4129,\n",
       "  'tel': '4f6ba1836f821bbb8679426b81b9268f'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4130,\n",
       "  'tel': '664536f8f05a6a0713bba93cefd4c0f3'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4131,\n",
       "  'tel': '9dd4d654354c9eea63ba5d30c5ba69f5'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4132,\n",
       "  'tel': 'c1ccb69b950b09446d71f4cd05261070'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4133,\n",
       "  'tel': '8645350da3c10af3ea03cd0eb1fba6e2'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4134,\n",
       "  'tel': '62b76058843987f1e99001c629955bef'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4135,\n",
       "  'tel': '82ab3675a3cf17ebf4cc7bce28cce1d7'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4136,\n",
       "  'tel': '169ea3168b9f8c2e64dde86f31063260'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4137,\n",
       "  'tel': 'd2a945dbdbe154e47ea5d12ed482295f'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4138,\n",
       "  'tel': '8b65dac2554945fdca8176f54060c157'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4139,\n",
       "  'tel': '9badbf107b6bdd43affa56f81f9dc19d'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4140,\n",
       "  'tel': '83c7c24cb758be0a904857efe3e1777a'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4141,\n",
       "  'tel': '2699af99cda21eca2eb04557cc2c98a5'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4142,\n",
       "  'tel': 'a06f5e04b56e86fa6d9a92c2c066384f'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4143,\n",
       "  'tel': '2367f6deddb5a9c4da08162f5ebee64f'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4144,\n",
       "  'tel': 'fd54c8ac1b5036805ed5e311f44c1a20'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4145,\n",
       "  'tel': '4af733aa04f454ce8b4061660c1f3727'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4146,\n",
       "  'tel': '64ac3abe0eb07546e8d6575b1a1011f2'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4147,\n",
       "  'tel': '706f5a2fe31b81e269ebe946ae269bce'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4148,\n",
       "  'tel': '97d699944b993be4bfbc4705aeb627f7'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4149,\n",
       "  'tel': '49d1fc2624f7f36010573fb3b92cc31d'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4150,\n",
       "  'tel': '4535d18892fabbae3ae5ce9251a4b856'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4151,\n",
       "  'tel': 'ae7a75e641de9111369751c83cae2882'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4152,\n",
       "  'tel': 'cdd701b4977f3b08acc2238329d5658c'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4153,\n",
       "  'tel': '134c169547e15f82737d00f9300996b1'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 4154,\n",
       "  'tel': 'b99ea24598c6542b6fbca63f81dc6803'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4155,\n",
       "  'tel': 'f6a1ee38bfbb74264b5da288d1261670'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4156,\n",
       "  'tel': 'd5f103ad05008b34a7dd22e6d6d1059d'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4157,\n",
       "  'tel': 'e474aa0c67ad6568b0e7f9f653917e01'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4158,\n",
       "  'tel': '7a5a358ac2155657d12a7dbaf31e1e99'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4159,\n",
       "  'tel': 'a88bd76d15990c030dd8850a8d894484'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4160,\n",
       "  'tel': 'f30f8e8818c5d87686ad5fc0cb524ed9'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4161,\n",
       "  'tel': '1d9475c289aab250786f6d6bd94b0103'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4162,\n",
       "  'tel': 'd506e8e7c7cf05d989505bf42fd1462f'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4163,\n",
       "  'tel': 'c8f6103b8c1f15bf3e1afe20b89bf89b'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4164,\n",
       "  'tel': '296a8a1bf72ca2015c019798b8fdb259'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4165,\n",
       "  'tel': '481732ccffd14b969d6b5a7dca0aa840'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4166,\n",
       "  'tel': '534983d9af7ebdcfc3aea504be4bf833'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4167,\n",
       "  'tel': '7a10c6178b62e80963f1ac6861723afb'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4168,\n",
       "  'tel': '8e5f9e13c9e1d31cebb9616328907fde'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4169,\n",
       "  'tel': '021c746ea0318beb18c98960da56740b'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4170,\n",
       "  'tel': '0b238f2577af8de378df7ee0e4bd76fd'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4171,\n",
       "  'tel': '13cd00c8177e7094c5adf128ec2c5839'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4172,\n",
       "  'tel': '618471cbd04c37527bdd162b165fb10b'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4173,\n",
       "  'tel': '09602e1d5e96c0819ac4a400f91add8d'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4174,\n",
       "  'tel': 'dfd48e7378045c270f5c5a02cd108a99'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4175,\n",
       "  'tel': 'e81d2754e277246f193a44ea01f7a683'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4176,\n",
       "  'tel': '5ba0af31f85130c69d6cbdd66ef97c0d'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4177,\n",
       "  'tel': '2eab4af504ff78ad977ed77067306fde'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4178,\n",
       "  'tel': 'de215c0b90af42d2fca7f36b0dad4241'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 4513,\n",
       "  'tel': 'a199cc47f4e1cb1eb3cbcfd1fbca7991'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4514,\n",
       "  'tel': '0eb602952b4dd1d137a01175955eeec7'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4515,\n",
       "  'tel': '0892440e97adaf2f089b5a58c48790a1'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4516,\n",
       "  'tel': '7d7473c3dc63807897069188902ed379'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4517,\n",
       "  'tel': '24800f591cb65a7c6f6d615f077fc89d'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4518,\n",
       "  'tel': '6549bd0a1030a89601b479805ba453dc'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4519,\n",
       "  'tel': 'c21162eac389da724ed4b9ee91371d91'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4520,\n",
       "  'tel': '7f6909768de067e68ab1abed9f982679'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4521,\n",
       "  'tel': 'ad29d8e680d6fb6685f9c1b0e100951b'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4522,\n",
       "  'tel': '794c02856f21a6be3320f570e7ef3420'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4523,\n",
       "  'tel': 'f67710c4f770fff4fa53a67f4e8d8366'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4524,\n",
       "  'tel': '39f3c060f552997ce5ea4144ede41d69'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4525,\n",
       "  'tel': '6b32f2059d41a20698580750aac27a64'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4526,\n",
       "  'tel': '3add0555d3579b81e1a156b9fde36113'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4527,\n",
       "  'tel': '00ff78cf31c940b6ca6f65f6306060b9'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4528,\n",
       "  'tel': '09edda20f23df6fbb216d9ba4120b94f'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4529,\n",
       "  'tel': '9cd0044c0037834d038f409e2f74efe9'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4530,\n",
       "  'tel': 'ff386ee8cd70c6c31a8fb8a4f8328aab'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4531,\n",
       "  'tel': '65703db1acc57a628cbfeb1a565819fe'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4532,\n",
       "  'tel': '5fc69d2bee7004220b2fe6537aaaffa2'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4533,\n",
       "  'tel': '62e1c2616a35d77c2e4a430836bdd366'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4534,\n",
       "  'tel': '0347670ac5b29252eb0ebf70d2aec99b'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4535,\n",
       "  'tel': '5c18b60b4438bc43dfc94eb15df14866'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4536,\n",
       "  'tel': 'b51722bebec1d355a66133e279254ca8'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4537,\n",
       "  'tel': '47a1529a95a088fe0f5a46045d9886ad'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4538,\n",
       "  'tel': '488610237044aa0329f11d75ce1eede1'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4539,\n",
       "  'tel': 'a62f8e6ea2ce32093110f2417264d65f'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4540,\n",
       "  'tel': 'b0ded5cee72c1aabc67b528c4b974a54'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4541,\n",
       "  'tel': '2af39bfc2d2a0507f2cb7f13748c1138'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4542,\n",
       "  'tel': 'a7bb711c1fb0520a0505c7d470ab6a6c'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4543,\n",
       "  'tel': '47f7b0a506d9b7e205b6f34773ab841b'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4544,\n",
       "  'tel': '99881c2ff1f782926ff3751ad4675cdd'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4545,\n",
       "  'tel': 'bb1f0d00476d9ab9f7108109f04ecb04'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4546,\n",
       "  'tel': 'dce88e9621137c99d376e57cb76bd986'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4547,\n",
       "  'tel': '46e7323f5466235bec75181640ebd598'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4548,\n",
       "  'tel': '90315818fa4f140bbbe2295bdee723b6'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4549,\n",
       "  'tel': '19442285247bfed365fc0b72b91d7305'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4550,\n",
       "  'tel': '14c817154587a49ba548a39af86f3ca5'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4551,\n",
       "  'tel': '388a895d7fab6af0cf95c9bf7603bf56'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4552,\n",
       "  'tel': '410aeec29e1b952c69f9141e60e71f18'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4553,\n",
       "  'tel': 'b9de6064b2b8fbdd2fe350c9da880c0b'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4554,\n",
       "  'tel': '97bb11eee27019e6424b4ea8ca637e90'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4555,\n",
       "  'tel': '89f94e90f1163139a1a8e37f1b656b3b'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4556,\n",
       "  'tel': '264e4489694f5ded07c36bdeab0bb526'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4557,\n",
       "  'tel': '86069ce3c98f7657c256d24a89a3f793'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4558,\n",
       "  'tel': '524c84639df8e50348dc016fa2c64d08'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4559,\n",
       "  'tel': 'ba3077b953215cb603d40e27faf5e343'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4560,\n",
       "  'tel': '52cdb790f4722ec231428e6f0a098d8c'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4561,\n",
       "  'tel': '2104275051600d92aea31dbc1ab47f0d'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4562,\n",
       "  'tel': '886e30452f06407706710452776afd81'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 4563,\n",
       "  'tel': '91bdbad1d05c24aae0222742cfb63f2d'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4564,\n",
       "  'tel': '1314ecd5bf5cffb2682bca0949301891'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4565,\n",
       "  'tel': '991b78ad85cf8d2ee6dcf93dc6dd5898'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4566,\n",
       "  'tel': 'c4e1a718c97d44a9b09aab5c30addcd7'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4567,\n",
       "  'tel': '2730bb100c2bd7c8fb722411a7b13cb6'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4568,\n",
       "  'tel': '7f626fc22274a7347e4d25f8a4190e0c'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4569,\n",
       "  'tel': '292842ca4cbad712e68fb7f58c27ece9'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4570,\n",
       "  'tel': '4e1fd2277d130b25841632a18a269c48'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4571,\n",
       "  'tel': '3a9f690b86d62ea3059c494ecc7e992c'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4572,\n",
       "  'tel': '94f3119ee2c005680dd2078eea59599b'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4573,\n",
       "  'tel': 'd724a7031bce3bdc3918286af89a14e5'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4574,\n",
       "  'tel': '3f7de3de70589fa79946118031eaafde'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4575,\n",
       "  'tel': 'd04f7b43875dd7977ea7ebccd575b4e1'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4576,\n",
       "  'tel': '3c4a61577b4625888ab4be48432e91e3'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4577,\n",
       "  'tel': 'f2580932b3216f52f39c28e085b0de6f'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4578,\n",
       "  'tel': '63b86a62d190269df7a155d3beddfe78'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4579,\n",
       "  'tel': '6c7c5dcd8b604da946a9bd2b5615cc48'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4580,\n",
       "  'tel': 'b2ed38095f149ddb20b66ea7e6ac4bd5'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4581,\n",
       "  'tel': 'f2779307a68089bbeb2c13b3ebfbc820'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4582,\n",
       "  'tel': '25444b68de04cdba4ce05ad03576626c'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4583,\n",
       "  'tel': 'baffb63f5395a3be6dcf65ab4288a337'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4584,\n",
       "  'tel': 'd00c7b8f7c4ce1c70290477b15502e15'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4585,\n",
       "  'tel': 'aa04863f524c85723bf8e9800bd5775c'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4586,\n",
       "  'tel': '9b7376a77af775af75a7d9c56fa933e8'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4587,\n",
       "  'tel': '4d474c4c3d90264e8820afe4b765f4b4'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 4588,\n",
       "  'tel': '574b2ed30093f4b3b81d60fe2485e1f8'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4589,\n",
       "  'tel': 'f19ca6936c6c3ac2e067e17a912eada6'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4590,\n",
       "  'tel': '44fdaa1e698d41be6ca6ae46e577fc82'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4591,\n",
       "  'tel': 'f92d7ba2ed9a3360928cf2c14bd24e1d'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4592,\n",
       "  'tel': 'e11424ac748ee015fd9c6d26d0e89a68'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4593,\n",
       "  'tel': 'dada040584639284d45a9d4b03b3e741'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4594,\n",
       "  'tel': 'ab7850f9299d2c414fad2446d2eeaf8a'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4595,\n",
       "  'tel': '5ae0362dc03f07a4edd88a769b4ab9aa'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4596,\n",
       "  'tel': '28fa0942de0155a0e1151300fa0961fd'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4597,\n",
       "  'tel': 'a463042027b37288e0a280307e85ec51'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4598,\n",
       "  'tel': 'f2efcad995ae29b1ac92ecf7eea91bd2'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4599,\n",
       "  'tel': '2ac681f250bb7488b73086c05d2e10d8'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4600,\n",
       "  'tel': '84a58b6eb6bc54cd87c48e0241499ccf'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4601,\n",
       "  'tel': 'aa8f22a92537678538e8a6f36915a57a'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4602,\n",
       "  'tel': '1f5d20ef7d4ec215cc245023fbb72cf2'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4603,\n",
       "  'tel': '384bcaa0423516fa79875295cd4a7d89'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4604,\n",
       "  'tel': 'ac78e197b501d0b18cea2a092033b22f'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4605,\n",
       "  'tel': '87a44e1c5336111c279a4489954bfc65'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4606,\n",
       "  'tel': '73f659da2d47ea48e2697770320e4446'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4607,\n",
       "  'tel': '9ee32804ef7afced7fcea28c8af7e9b7'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4608,\n",
       "  'tel': '94f504d9719ca8f96861c2a2bc7992a2'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4609,\n",
       "  'tel': '39e4e1ec4c20eb02c207c76362fb984d'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4610,\n",
       "  'tel': 'f929d4510c3ff399f6b7175baee21ee6'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4611,\n",
       "  'tel': 'd154ce4866b14062d08a927be302871e'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4612,\n",
       "  'tel': '43e64218da38cf74260013da95ca6cb2'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4613,\n",
       "  'tel': 'fcaa5dd6ab3dcdce8ecee04c2c10846c'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4614,\n",
       "  'tel': '86cf0d7b38ade0a5b6ba7e4d4d54195d'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4615,\n",
       "  'tel': '2da057c8dea2b45a36ecf63f8e54c11f'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4616,\n",
       "  'tel': '88cb076224042e4d819e44600135eb50'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4617,\n",
       "  'tel': '05840f2f5a0be45217ec30c9db0236b4'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4618,\n",
       "  'tel': '7a4d43e99fb3017aaf1674f7af2a361d'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4619,\n",
       "  'tel': 'c3cc720680d3732b420d461d288fe2d0'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4620,\n",
       "  'tel': '0715392910f4657b43f8478a2ef52fd4'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4621,\n",
       "  'tel': 'a35b6b6d1aba1b17e66ec0cd547fc453'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4622,\n",
       "  'tel': 'fdbb55e6785efdea1dc8170ab5381634'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4623,\n",
       "  'tel': '662eed510398b9b14a4daa5ea7ae89ed'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4624,\n",
       "  'tel': '1a9bf06377c3083db1a3b1fb4c9c72d8'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4625,\n",
       "  'tel': '50acecbf60cb60bdb4077c6a7cad659c'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4626,\n",
       "  'tel': '14dce9a2b85bb2f843ecd672c0b8f732'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4627,\n",
       "  'tel': 'f6747eeb0ece0951c312be10ce6b23f5'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4628,\n",
       "  'tel': 'ad48b06fc145e8568ac227372429747a'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4629,\n",
       "  'tel': '349ff479cb84a1e8a2a05007dd6c5da9'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4630,\n",
       "  'tel': '55dc25fcfec8bd26d8c6505fda836927'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4631,\n",
       "  'tel': '9b402642214ad570a2df2371be0175ae'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4632,\n",
       "  'tel': 'd108f80b24a69e39f37b6342fd45284f'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4633,\n",
       "  'tel': '652800faa28695f5cb4f98a0e4f0e2e4'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4634,\n",
       "  'tel': '3c66069bbbb870e23baf7ef8c18decdf'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4635,\n",
       "  'tel': '879da2d022d0ab236307e778c61a5018'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4636,\n",
       "  'tel': 'b9fab901733f6130885123fb9618f17e'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4637,\n",
       "  'tel': '76d2f47e5b2525609b0d3942d7f2e1ac'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 4638,\n",
       "  'tel': '8a735567aa80a42e089b8693d43195fc'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 4639,\n",
       "  'tel': 'f78810d7bff2b11ba75c6e07606c1deb'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 4640,\n",
       "  'tel': 'a7602e3dbecfced2b5ff56de7b3f27f3'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 4641,\n",
       "  'tel': '2322c004f633df0f01e563129d7aa879'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 4642,\n",
       "  'tel': '61a8cd845d4d2ee2537a98565f4ca5b8'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5019,\n",
       "  'tel': '4ef51a52a29d3e44a8a6f3a6f691a5ab'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5020,\n",
       "  'tel': '68821606863282df4335186b4dfdfad2'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5021,\n",
       "  'tel': 'c7d9d0a82c149bb11058cf178d05517e'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5022,\n",
       "  'tel': '81f403e9964341f4385b0daa55428405'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5023,\n",
       "  'tel': '4cedc04e68bfe554f6a0a5aa18808524'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5024,\n",
       "  'tel': 'f60e8bb75c486245765c22ed4d858381'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5025,\n",
       "  'tel': 'e31c887416c0f79d4907683b75a2a2e0'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5026,\n",
       "  'tel': 'b7c9f1651b2c4ad13266b7068cd4ea6b'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5027,\n",
       "  'tel': 'a472953b1b02f079c8d708966bedaa3a'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5028,\n",
       "  'tel': '3a25b3c2d2308294b93faf668fd426a6'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5029,\n",
       "  'tel': '6cde52170c4ea99a5d1cd69a4c772f73'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5030,\n",
       "  'tel': 'e175896c262b60781d63594db0d97d7a'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5031,\n",
       "  'tel': '7653deb2c8a93830347849c373459e28'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5032,\n",
       "  'tel': '77048f441e9955ab9434137e616dcdb9'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5033,\n",
       "  'tel': '5c186f15a702fd46fe6ae1e1501ac8ce'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5034,\n",
       "  'tel': '0fc23a579e0e9cab859a37f5ae3981a6'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5035,\n",
       "  'tel': '0971453b388459a9f3ff791b24f8fa26'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5036,\n",
       "  'tel': 'f679ac9814b825e938b1889591d4f1aa'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5037,\n",
       "  'tel': 'bca6a4ac1d41d45c8b882b232a4c2590'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5038,\n",
       "  'tel': '11d5aa04e0e7f390ebb5f42de59970e9'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5039,\n",
       "  'tel': 'fb9f68c6783e37d86c7944857e53a222'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5040,\n",
       "  'tel': '7c12ac282796905b28a8c1c553000416'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5041,\n",
       "  'tel': 'e6ec23a6b53b0cb2308825f128f90446'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5042,\n",
       "  'tel': '11eb214abe6fa6a169d6858e6494ea84'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5043,\n",
       "  'tel': 'c42c33f6e20d8c9d6482552a7cab0160'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5044,\n",
       "  'tel': '831b4110ca09d6663b5ccf85571f3458'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5045,\n",
       "  'tel': 'c30ddf6734c87bb20d789728c3f305c1'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5046,\n",
       "  'tel': '9de2d82f03801044d0a85bcb72a8a6b8'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5047,\n",
       "  'tel': '57366ffbd111398d9c1cc280ce0885e1'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5048,\n",
       "  'tel': '297f196a43c92c8f5222e8e45d31354b'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5049,\n",
       "  'tel': 'f5b3f4321ca7d0278cda46a17e6fddfc'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5050,\n",
       "  'tel': 'e1be290c25eda8d86bc7da5f71e6ff09'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5051,\n",
       "  'tel': '6e8827b8c6b7e2eeded1b106a30511b5'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5052,\n",
       "  'tel': 'ac83406b9fb7f4d2dd4154feae23f77b'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5053,\n",
       "  'tel': 'd0e7d5b549db327a40ddc348c9dc840d'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5054,\n",
       "  'tel': '055a519aa0ed41c73be1e618c4f40ed0'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5055,\n",
       "  'tel': '3d6823bb36871417f07365522e9c32dc'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5056,\n",
       "  'tel': 'a18ea9ed9a803eefe3382b4c32b0348c'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5057,\n",
       "  'tel': '7ed1d8b5ec3f41c5a74fc0d880796431'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5058,\n",
       "  'tel': 'bf4050611d6733ad0132465639330b26'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5059,\n",
       "  'tel': '94af69a8a228eb28eddab53491db147b'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5060,\n",
       "  'tel': '9fc42f845f761f62e50efa352e5219fd'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5061,\n",
       "  'tel': 'd9b7f0e19aa48b9a02ba235ef3179fd9'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5062,\n",
       "  'tel': '07b6356bb845d8796bc37cb5a2304fea'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5063,\n",
       "  'tel': '87997997eb3c290553300cb000b6214d'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 5064,\n",
       "  'tel': '819bef0df21596a96ef20a22291c61d6'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5065,\n",
       "  'tel': '7f73de3122ac1f079cf2e90a458571e1'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5066,\n",
       "  'tel': 'baf7deec056160f13f7cb197f113a824'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5067,\n",
       "  'tel': '3f7c225a7804fc088d751f0c65616151'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5068,\n",
       "  'tel': 'e81611d143dd4fa02d71a28c35d583ee'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5069,\n",
       "  'tel': 'a89de1c66c9c12e2ea30d8bec2b918f0'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5070,\n",
       "  'tel': '869daf55619fcc1e71041507065c9e8c'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5071,\n",
       "  'tel': '96decee5dafad17dfe50aced88da3550'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5072,\n",
       "  'tel': '18f02eae6af6c4951cc99037cee79fe1'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5073,\n",
       "  'tel': 'ecf315393e91dacf7a5669e2e27f49bf'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5074,\n",
       "  'tel': 'b1e2678b9b286b83649f4fda1fc98238'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5075,\n",
       "  'tel': '80e1d73c9712bd084820f658cf80bdcc'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5076,\n",
       "  'tel': 'ac238221df4d6a8ef4176c7a1c850352'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5077,\n",
       "  'tel': 'b5e446dd7f142d31e09f45bfcfb4123e'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5078,\n",
       "  'tel': '80293f4c8f00df1f18519facd09d9885'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5079,\n",
       "  'tel': '6af4ef1f2e6b5c72af46f4710e17b0fc'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5080,\n",
       "  'tel': 'a67d8622324d89beea9f7aa950b3fee6'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5081,\n",
       "  'tel': '255206594daf8a8d6abb7153e36d7987'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5082,\n",
       "  'tel': '53ab8ca9aaf35b15bdb4c6928e20ffab'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5083,\n",
       "  'tel': 'b5165d10ffa114ed122deb057bd83f44'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5084,\n",
       "  'tel': 'b66fe2faa975d5efa8068475cc41c387'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5085,\n",
       "  'tel': '05d16a9d11e60fabfb88016ffa2a5d6f'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5086,\n",
       "  'tel': '468c6ec8a9d55e51422243b0371fe4c6'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5087,\n",
       "  'tel': 'aa446c1bb8c5e40543335eec5921a1e8'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5088,\n",
       "  'tel': 'ae2ce8160cbe89280b031af7a703e4fd'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 5089,\n",
       "  'tel': '51e3fc114db9f882bbe01978b1e74ef6'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5090,\n",
       "  'tel': 'c65ed35071b1c8a5ce8e68f705a23d2d'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5091,\n",
       "  'tel': '3ef4e7e0d1d249079250d4a9696529d8'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5092,\n",
       "  'tel': 'ee4d3cb3c907ee03613653f7bffbd8b2'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5093,\n",
       "  'tel': 'f6304f505008504adc9763e6518cb9fd'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5094,\n",
       "  'tel': '3e78623b9b43ff3b6f1d573cce851d68'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5095,\n",
       "  'tel': '4d57e3fb44de621718816c636fd987df'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5096,\n",
       "  'tel': '7893704748d540a5c0a72e1e8e3b4047'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5097,\n",
       "  'tel': 'a1d732c5ba5f3feffed20671708536de'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5098,\n",
       "  'tel': 'aa40020af2969b7f897ffa13c71bb6c8'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5099,\n",
       "  'tel': 'ac52d93c41e2b7fef978858fd9dd1660'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5100,\n",
       "  'tel': '898392dc04535b5ec3ab43c1eadde4a9'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5101,\n",
       "  'tel': '6ae2abb296d3037abdf5b2e66d0c790c'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5102,\n",
       "  'tel': 'c5ce4040e9534513aa6359a4747960cd'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5103,\n",
       "  'tel': 'a81132c2770cb2fe9eaa185f6b413959'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5104,\n",
       "  'tel': '476ac48c27a303080ae780927938fe6d'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5105,\n",
       "  'tel': '33ca6d17c9285580e5cf509b2d07a816'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5106,\n",
       "  'tel': 'ef7e71fa6db62d0c277573a0d43d8cd7'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5107,\n",
       "  'tel': 'e1adda67823bc469d462811957762ad7'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5108,\n",
       "  'tel': 'a694894c6d7a5ccb3ad587639675af40'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5109,\n",
       "  'tel': '66a20b6f2c087859cfadba90be433e5e'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5110,\n",
       "  'tel': '5400016e3c6018b5143408ddec36fe40'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5111,\n",
       "  'tel': 'fc0f4bb3f9d0c78123a4fed8ce6bfbcd'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5112,\n",
       "  'tel': '6dd6e2217bd2ea1e5505fc205e16abd0'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5113,\n",
       "  'tel': 'bca7e7d3cfc54f69d0488b0157be048c'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5114,\n",
       "  'tel': '9f74759611ad1a88b13abd5f1ab21bee'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5115,\n",
       "  'tel': 'b1040587789a056799cb91df0681cc43'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5116,\n",
       "  'tel': '1fdaa767755dd3d852d11110f8e2a73c'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5117,\n",
       "  'tel': 'c5120c2c51cf3581419d2cc8a11736ff'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5118,\n",
       "  'tel': '8df8f71dfb2594349a6181b799660481'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5119,\n",
       "  'tel': 'b1fc7610b592f1701138ed52bf01f7fa'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5120,\n",
       "  'tel': '11e1144bd36429433eb4b091f08d8dfa'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5121,\n",
       "  'tel': '35bff4c392c2468855a4dbcc23116faa'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5122,\n",
       "  'tel': 'fc4a816ea3d79c91962f019580197401'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5123,\n",
       "  'tel': '9d20b6b0872ffa6ee3324267bcded052'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5124,\n",
       "  'tel': 'b056f60f8dacd277f0462b4734d89dd0'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5125,\n",
       "  'tel': '127aa5eb99698c4c510f035d47241b4a'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5126,\n",
       "  'tel': '9db2961d6da46a8450cbd5d504617423'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5127,\n",
       "  'tel': '8c0bcf332863c18c2da61e4eb7925ad0'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5128,\n",
       "  'tel': '662eff53bdaf6ba710437d6bc7940b35'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5129,\n",
       "  'tel': '5dc0841914535d72bd558cab501acba4'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5284,\n",
       "  'tel': '3c5bb16dfa6e27d0b00dd12352e6963c'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5285,\n",
       "  'tel': '81420ed7ad7db1a22a19c280aaaff496'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5286,\n",
       "  'tel': '7c9b7ffaf1a8b3e8750e834eafaf7d5f'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5287,\n",
       "  'tel': '8d53a4d4d5b3cbfd47d03ece051c301d'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5288,\n",
       "  'tel': 'd6f73322f9230b5a6a9bc8d7498ae80e'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5289,\n",
       "  'tel': '3fbac3b4cc91120425cf38b72e0faca8'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5290,\n",
       "  'tel': '4663aef86ed6c0f033202853d1533cfe'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5291,\n",
       "  'tel': '25c611b6f05d65ec7b474064b1593252'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5292,\n",
       "  'tel': '791672818be3ba23c7af7edb0211a9d8'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5293,\n",
       "  'tel': '7f02088a3003a69865d68283632a001b'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5294,\n",
       "  'tel': '6a2329009613464c8743d8b8317d421a'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5295,\n",
       "  'tel': 'fffeabfe889cbcc92828206684e15358'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5296,\n",
       "  'tel': '895fbfa0b7f77a51bb2a7edc6358d260'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5297,\n",
       "  'tel': '2b8698b5854e5289aed88a7d050604f8'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5298,\n",
       "  'tel': 'd36cc0a619b9c68e8663d9f06109d971'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5299,\n",
       "  'tel': '13d4b28c7b1a3764b5a33d1cd8bc19a3'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5300,\n",
       "  'tel': '895b23179e3442a99f374ba4644925f9'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5301,\n",
       "  'tel': '9d3d15eceae8fc50b8d24b57acf3ac66'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5302,\n",
       "  'tel': 'cf92112ce1cc39ae2d0692e860ec83e9'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5303,\n",
       "  'tel': '91b3694738df3b265a51b54d1d82df3e'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5304,\n",
       "  'tel': '57019245bb1c092ef4daa3d96682f1f8'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5305,\n",
       "  'tel': 'fb715ac9d11f0525fa8a54887d42dfe9'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5306,\n",
       "  'tel': '7b7b2526b95273e6c353a8c5402f3592'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5307,\n",
       "  'tel': '69d6c0a3955597ea87f43327a7c3e52a'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5308,\n",
       "  'tel': 'f9b8d3dfaadb1ea380079f3b36d932b9'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5309,\n",
       "  'tel': 'f10827faad8ca4ebaf98f8286048c1b6'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5310,\n",
       "  'tel': 'd497bae62316c24b4454848fc0a96144'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5311,\n",
       "  'tel': '47ff6c0ad743ed16b0b63f8276fc7a24'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5312,\n",
       "  'tel': 'af1831318b31e2d5e550b00d323c1a6f'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5313,\n",
       "  'tel': 'cd0ae6ffb43366e6662be43fbb68f2db'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5314,\n",
       "  'tel': '112f2e05ea0bc9c58ed2ce8a85079e98'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5315,\n",
       "  'tel': 'c079c0e8b618a11c109f2616556e3cf7'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5316,\n",
       "  'tel': 'b32b3b5cd9ce29db39fdf6142630c822'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5317,\n",
       "  'tel': '3c579642c3f11f235943d45aea274590'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5318,\n",
       "  'tel': '25978effcaf7e5af3bf9ade0160d29a1'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5319,\n",
       "  'tel': '6d1e846dd0a0cdd93f56ab0e08dedfb5'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5320,\n",
       "  'tel': '12d54b515f539dd819cd6f940cc9520a'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5321,\n",
       "  'tel': '651e4bed9ad65290fcce713b84fd95d4'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5322,\n",
       "  'tel': 'b53941a33f849aec48ac6a1cbe91ab5b'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5323,\n",
       "  'tel': '1e69b41ee0b4e702bdf39eaba08743e2'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5324,\n",
       "  'tel': '20f822fbf787c3e089cfaa9894efbe88'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5325,\n",
       "  'tel': 'b2db4317b10ff1550c6e4a31e46ff9d4'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5326,\n",
       "  'tel': 'd2eacc032af0db61298f752ca82be4a4'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5327,\n",
       "  'tel': '1e84f3f1d5793c9801e2516b505d219a'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5839,\n",
       "  'tel': '32c793a2f618ea17150a96bc9aac1232'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5840,\n",
       "  'tel': '0a126f40e46b48ea41ace3942a516dc5'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5841,\n",
       "  'tel': 'a55214a4f7a4480d3cfa719e7ad731bc'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5842,\n",
       "  'tel': 'ce1173ed55e2fdb4081ebd06ca41ae7c'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5843,\n",
       "  'tel': 'e90c7e199b88c61e6d25a2b374640e3e'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5844,\n",
       "  'tel': '381bfa58fc6abafb64568a12267d81aa'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5845,\n",
       "  'tel': '3a7a061fe6e0151ee4e67e68229b5260'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5846,\n",
       "  'tel': '32d1f7e162ba46a6fbeffd635fa3a8c4'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5847,\n",
       "  'tel': '9c22a0806024127ecd17899959d80dce'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5848,\n",
       "  'tel': 'a186bf98d108685b64d4b816f250d462'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5849,\n",
       "  'tel': 'aa21652f7fc77878a4fd53feaef2ace8'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5850,\n",
       "  'tel': '2ebb085952192c25854b73a6fda57478'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5851,\n",
       "  'tel': 'ced8886221b5c8b0c5c23e5a1b99fdf7'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5852,\n",
       "  'tel': 'e28ecbaef947b5d433ab64156589e8c9'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5853,\n",
       "  'tel': 'c90900605c3d9f3a01c96c3fcdd3da2b'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 5854,\n",
       "  'tel': '4e09033c6363f369e118e3106d204570'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5855,\n",
       "  'tel': '7624949220e19d6a1361c1115b9dd419'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5856,\n",
       "  'tel': 'b60e0d20e79fe87bd45d81e25a1c1ac2'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5857,\n",
       "  'tel': '58f403cc53d8c7fb769340a99bef8f36'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5858,\n",
       "  'tel': '105927db32a6a7833eff23e490a3e658'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5859,\n",
       "  'tel': '88560411072ce8cae5ff2dd1dc4d5784'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5860,\n",
       "  'tel': 'cc271bc36387354642de27ed1aa0cbd6'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5861,\n",
       "  'tel': '8207cb8eb53328385da0b0b67c2eac29'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5862,\n",
       "  'tel': 'bd1a755d6214443efa601a4927c858f1'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5863,\n",
       "  'tel': '6e03ec3e264362194062b4d56eb0940b'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5864,\n",
       "  'tel': '8a2fa20fb803a17d8d951194487313c7'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5865,\n",
       "  'tel': 'f7dfa223ae1975255f9678a9aa51b208'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5866,\n",
       "  'tel': '6b0a05f6819c4fd5453a88470e00e29c'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5867,\n",
       "  'tel': '16141d3c529db5677a0cd33a64421c3f'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5868,\n",
       "  'tel': '88ec51b211e7fcacd7c08b4ef2ceb8cc'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5869,\n",
       "  'tel': 'bfb931f07b366e4ddf785cfbd1617ff0'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5870,\n",
       "  'tel': '0aad42e836b494b40f5c75c0032e8131'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5871,\n",
       "  'tel': 'f842c1d23fc27e19da8395a740e9be56'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5872,\n",
       "  'tel': 'a400e9dba39872a4d54a6fa926e7fc9e'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5873,\n",
       "  'tel': '19791e30eec1b4f10fc8502b6838f019'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5874,\n",
       "  'tel': 'f0d5a53707cda13abf3e5067ef1683ff'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5875,\n",
       "  'tel': '9b35052374494bfedc8f456014e9c223'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5876,\n",
       "  'tel': 'e50b2758c6f7fd1e81cb744fbaaa01a6'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5877,\n",
       "  'tel': 'ac575425048ecce68749ac4652c4ff98'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5878,\n",
       "  'tel': 'a62f5e3859a109360202fc519910ac5b'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5879,\n",
       "  'tel': '33937544d170a1f0918673dcec8f5ae6'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5880,\n",
       "  'tel': 'c5d847cd5b8fa7dcf7bc93a8a988f92c'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5881,\n",
       "  'tel': 'aeb1c54c4b1a153cfd4dc7de3172aaaf'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5882,\n",
       "  'tel': '73068a62deaacd349e290d0016a1de0b'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5883,\n",
       "  'tel': '4ca06d63e45eac96f804db69c9a17e49'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5884,\n",
       "  'tel': '227e8a8f7a03d2370846aeb636084f4a'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5885,\n",
       "  'tel': '87abf1ef8704d091412929a891c4be87'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5886,\n",
       "  'tel': '9735b7d464b39fefbf0eeb2fcc0cccee'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5887,\n",
       "  'tel': '6c1626aa4f608bbf148984401a527a4a'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5888,\n",
       "  'tel': '9e25fdc26e7bae6f8b86fc36e96ca569'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5889,\n",
       "  'tel': '732c5996fee2dca5866b43bb0bcf35fe'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5890,\n",
       "  'tel': 'f706e1cf77b795c156443d08c1a0cffc'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5891,\n",
       "  'tel': 'c79fa3359615beffb7afdd7f481acaa9'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5892,\n",
       "  'tel': '2b31eb8a8b42a3a39ecd30259a4fabc3'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5893,\n",
       "  'tel': '5d8b9737ca392a46340d45a7e91f1777'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5894,\n",
       "  'tel': '549eb9b3bea3f2d7a5dea3cac9be59dd'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5895,\n",
       "  'tel': 'bc0ab916f5d5fa6deb3135a4febacfd1'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5896,\n",
       "  'tel': 'daedeb9c637ffa84a8d3d211d30ca1b4'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5897,\n",
       "  'tel': 'e6771c6bd05145dd0611e628529ba64a'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5898,\n",
       "  'tel': '333bc47d9ec462d09ddfdca9213fafdc'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5899,\n",
       "  'tel': 'b3514288c43bccd65f9690bbee4add95'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5900,\n",
       "  'tel': '494a451ca8f7f089251b164bf144055a'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5901,\n",
       "  'tel': '99e677e91304f53c90c90e8c151f832e'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5902,\n",
       "  'tel': '34db1d48912b980e79592cb76c50f474'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5903,\n",
       "  'tel': '19872c36f06b4cfa56948734d972574e'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5904,\n",
       "  'tel': 'fe71dd5efad18e272e76bbf117f729ff'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5905,\n",
       "  'tel': '403dd5220dc1173911b5fef0967c6e8b'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5906,\n",
       "  'tel': 'da052b37ff3c81ce969f47b83f3aa3aa'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5907,\n",
       "  'tel': '965f9676dcd1d7d2b883a37f61eb43bd'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5908,\n",
       "  'tel': 'bb86abddaff714828110148dd1059221'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5909,\n",
       "  'tel': 'e8965fb9f2b21233f64bb180f0e9dae9'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5910,\n",
       "  'tel': '84358f4228c375f554e72bd21f5e4e83'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5911,\n",
       "  'tel': '6772f65fb87060691b961571a45b90cb'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5912,\n",
       "  'tel': '2c3fc3c1e9adb5b498772c4acc10eb85'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5913,\n",
       "  'tel': 'e7c84ae82e72532662bc49660b68e7af'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5914,\n",
       "  'tel': '42cc3977bd5684dd61197c42d87a7b71'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5915,\n",
       "  'tel': 'a57967c60d70a44d8852504646fef7e3'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5916,\n",
       "  'tel': 'a3b1fd9e50cb9fa677edc893f903ad8e'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5917,\n",
       "  'tel': 'b9920100027a172824f3eeac4fae7049'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5918,\n",
       "  'tel': '9e632da6e4ef20185eb645b9a5ea7e56'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5919,\n",
       "  'tel': '0004cf89ef0671dbaeb28d7f1347cf56'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5920,\n",
       "  'tel': 'ec5aec4063d3befec1d51ebcb4128aff'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5921,\n",
       "  'tel': '8ded52486e4ac19861e4ef4af3f15680'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5922,\n",
       "  'tel': '40817257c3bd89c595ec1700d38dc0d7'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5923,\n",
       "  'tel': 'f10e1d620a8f21f3e26025d1275ca890'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5924,\n",
       "  'tel': '1f3e2f48f2e24cbbd1a594c61811e329'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5925,\n",
       "  'tel': '2946a3cc728288f83a8f1f78a5124547'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5926,\n",
       "  'tel': '9a4b2f8186f3607a08e9995487c9d0e0'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5927,\n",
       "  'tel': '07c0fa74e022b6ca933a0a829fb535d1'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5928,\n",
       "  'tel': 'ed5a436cad7dbcbc78252b77c99863ca'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 5929,\n",
       "  'tel': 'e0b6cc80de286dafc385f3b3caf59e68'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5930,\n",
       "  'tel': '0b0d93d0abdfff6e288be445e10e0224'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5931,\n",
       "  'tel': 'd9ca0a61fdbaf1bf5eb63f01b3a20b37'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5932,\n",
       "  'tel': 'e7b6eec2980aaf0766dceeca486d204a'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5933,\n",
       "  'tel': '545c3a7d1fa123e8e24ba2ef6f24dcd9'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5934,\n",
       "  'tel': '8fe0d0d5541d48891bf6234fec0613fb'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5935,\n",
       "  'tel': '8c92011d9368ea8db57b9589c1c06e6f'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5936,\n",
       "  'tel': '813c7dbebce55de5f4f3fb69f47f1447'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5937,\n",
       "  'tel': 'c6ec6d94b0769faebcd202b0d212f407'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5938,\n",
       "  'tel': 'bc668a352e055660090dc4d6d269b5a2'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5939,\n",
       "  'tel': 'f87b79edf3c50e471927a0c31b178945'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5940,\n",
       "  'tel': '73d2be53825e952c347ad4f588ebe90d'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5941,\n",
       "  'tel': '255d2b77593b5ee11a3a347f3c14ba9a'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5942,\n",
       "  'tel': '34b03d79ef9c087e119cb91a60ee928d'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5943,\n",
       "  'tel': 'a217051555a19192cba5e823a8af7240'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5944,\n",
       "  'tel': 'ec5b4751d9ea3e6cdf2efb23195348df'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5945,\n",
       "  'tel': '95f2a81296689750aadad2017604e779'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5946,\n",
       "  'tel': '8f02d4c9565bb48d2062f3bec4d7bd75'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5947,\n",
       "  'tel': '41b37e16e30cb2eca5ed99bf538b9672'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5948,\n",
       "  'tel': '611465e2babddf0ec75c925974377589'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5949,\n",
       "  'tel': '5c28717cfa8cc172921f601cca4805a3'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5950,\n",
       "  'tel': 'b54238eab00afe3953c3d41d1f8d3763'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5951,\n",
       "  'tel': 'ca8f3899e333cdeb02b01134cafe6622'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5952,\n",
       "  'tel': '692565547228c4a377a12a209517a26b'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5953,\n",
       "  'tel': 'e1f10ff77ea11e8a7c41f68a8eaff2a7'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 5954,\n",
       "  'tel': 'cf2000c07e845e4063e4fb96ea029cbc'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5955,\n",
       "  'tel': 'c182391ec795f24778619dfddcf3e006'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5956,\n",
       "  'tel': '77344f24215bb54b98f3b4ce18c3bd83'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5957,\n",
       "  'tel': 'c7be51aa30c2f37808039aa411583e24'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5958,\n",
       "  'tel': '2704149e391d1fabc3b3b14cfbf8eec2'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5959,\n",
       "  'tel': '25a42d2a18fe5a5e7ec2c5b469810d42'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5960,\n",
       "  'tel': 'c1560acca72480c2a43fd1ac20330715'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5961,\n",
       "  'tel': '01618c0b8e7638c94011990242070570'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5962,\n",
       "  'tel': 'e8f01fa293e937614097cc88d7cb6555'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5963,\n",
       "  'tel': 'a744df8360452b6d921fb10687a215db'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5964,\n",
       "  'tel': 'fcdb640ff2e34c4c2869b2ef3d8bc783'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5965,\n",
       "  'tel': '90a9ac025c0a430c2802713fa52efcbd'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5966,\n",
       "  'tel': 'b28f0e612147939706c126d8f0adcac0'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5967,\n",
       "  'tel': 'fdc9e328daa3d7226ab7ed47c778a86e'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5968,\n",
       "  'tel': 'c2dd7d3aeed621aec7eeed39bcf860ee'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5969,\n",
       "  'tel': '8cd9d4b7a51417ad803a59322025700c'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5970,\n",
       "  'tel': '79758032034ed0e8f1f32062a5dc3056'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5971,\n",
       "  'tel': '54bd23fb49efc7648c6b0e8948b8a30a'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5972,\n",
       "  'tel': 'c876b8d5e28ef12cc584688a1165ae2c'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5973,\n",
       "  'tel': '0ae72eb54dc1cdf9c9349e4a08bd0e8d'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5974,\n",
       "  'tel': '471abe62726ddcf5e5294be193ec4cb1'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5975,\n",
       "  'tel': 'eae68c0102a8ff35f155d912383d037e'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5976,\n",
       "  'tel': '5cb96ba0a55dd4447098d62e2acccb1e'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5977,\n",
       "  'tel': 'de07b54d16a07b4b6b7692dfa1f7d4df'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5978,\n",
       "  'tel': '43be4348900c4d7a1c1d5173f30cfe95'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5979,\n",
       "  'tel': '2ec3685bba271d2c5b0486bcc0870631'}]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_mission_data1():\n",
    "    '''\n",
    "    [\n",
    "        {'salesstaff_id':id,'customer_id':id,'tel':tel}\n",
    "    ]\n",
    "    '''\n",
    "    datas = []\n",
    "    df_customer_dict = df_customer.to_dict()\n",
    "    for index,salesstaff_id in enumerate(salesstaff_ids):\n",
    "        for i in range(index *25,(index+1)*25):\n",
    "            this_customer_id = df_customer_dict['customer_id'][i]\n",
    "            this_tel = df_customer_dict['tel'][i]\n",
    "            datas.append(\n",
    "                {\n",
    "                    'salesstaff_id':salesstaff_id,\n",
    "                    'customer_id':this_customer_id,\n",
    "                    'tel':this_tel\n",
    "                }\n",
    "            )\n",
    "    return datas\n",
    "datas1 = get_mission_data1()\n",
    "datas1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>customer_id</th>\n",
       "      <th>tel</th>\n",
       "      <th>salesstaff_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12231</td>\n",
       "      <td>17810ad73067e8706f5b67f2ec8834fa</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12231</td>\n",
       "      <td>17810ad73067e8706f5b67f2ec8834fa</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12231</td>\n",
       "      <td>17810ad73067e8706f5b67f2ec8834fa</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12231</td>\n",
       "      <td>17810ad73067e8706f5b67f2ec8834fa</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>29892</td>\n",
       "      <td>478d1ac970fbdbeaa1eb57d419c35e72</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   customer_id                               tel  salesstaff_id\n",
       "0        12231  17810ad73067e8706f5b67f2ec8834fa              4\n",
       "1        12231  17810ad73067e8706f5b67f2ec8834fa              8\n",
       "2        12231  17810ad73067e8706f5b67f2ec8834fa             26\n",
       "3        12231  17810ad73067e8706f5b67f2ec8834fa             21\n",
       "4        29892  478d1ac970fbdbeaa1eb57d419c35e72              8"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sql3 = \"select mission.customer_id as customer_id,c.tel as tel,mission.salesstaff_id as salesstaff_id from mission inner join customer c on mission.customer_id = c.id where customer_id in (select customer_id from mission where createDate = '2020-06-29' and status_id = 1);\"\n",
    "df_last_mission = pd.read_sql(\n",
    "    sql3,conn\n",
    ")\n",
    "df_last_mission.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'salesstaff_id': 5,\n",
       "  'customer_id': 487,\n",
       "  'tel': 'a12ddddece31a06b674e41d00c120a35'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 517,\n",
       "  'tel': 'ec4424adedf2ec7fc48c3bfeed54ef25'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 518,\n",
       "  'tel': '1090f73bb072604a7a7109d0c641306b'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 521,\n",
       "  'tel': 'c098a8f2bddc66cc97034adaa78d3f01'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 1034,\n",
       "  'tel': '80b0c7a8493a547b37fa691064119606'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 1037,\n",
       "  'tel': 'ebcb8da68545f196b27f050ac00d3dad'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 1040,\n",
       "  'tel': '23b9216d0a9ae32aaeaa6e7a17f0971f'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 1061,\n",
       "  'tel': 'd5ac33230fe75560b8bb886f17edd108'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 1063,\n",
       "  'tel': '3e3f86488efea70a761a3b6a539a3af6'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 1066,\n",
       "  'tel': '1dc2a72db1fdfe95344a1f4d8faabedb'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 1067,\n",
       "  'tel': 'e02bd377c279ce14f4d94baabdf45c99'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 1783,\n",
       "  'tel': 'b0c160fd845516b4f5f5572e4c7558fe'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 1786,\n",
       "  'tel': '32abfade8cc64824f66f939393d2d0fe'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 1788,\n",
       "  'tel': '2354e260860a3d2f9ddb7b664303110c'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 1830,\n",
       "  'tel': '764dd63c2a8a6772ac271fcb9b9f6771'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 1833,\n",
       "  'tel': '4f7aefeb62679f364086735df817bd48'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 1839,\n",
       "  'tel': '2ab4a9b547c96ea1d57a28675c8d6d1d'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 1841,\n",
       "  'tel': 'e9fa8e516d4971d7b3dada7a06131791'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 1847,\n",
       "  'tel': 'b0bbd0deda80542a95677f2f8805e906'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 2548,\n",
       "  'tel': '8e1a7294a39e3beef2da70cc58893c39'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 2549,\n",
       "  'tel': 'a29b331a55812a718abd64b00d6d4ad2'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 2570,\n",
       "  'tel': '4123d30acf205d751d48a576b42d7a40'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 2573,\n",
       "  'tel': '56863e8c1c8d1a48840b9ee6759d1a9a'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 2574,\n",
       "  'tel': '066d5a6f8cced27c0791e7987e2cd6bd'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 2575,\n",
       "  'tel': '3f442507687fbeb2cf16abba892521ae'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 2576,\n",
       "  'tel': 'cdce6c96174ae002a5273b85f49b8907'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 2800,\n",
       "  'tel': '86227e434a3b7292842b4a027ccaecd8'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 3419,\n",
       "  'tel': 'ad267711387aa5583dc6851b20a2af4f'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 3429,\n",
       "  'tel': '0bdfe5dc732dd3802172eebe91aba03c'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 3434,\n",
       "  'tel': '1445da6374aa16ac33464b6935498ecb'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 3435,\n",
       "  'tel': '1871fca1a8f514a8cd46998f0a396bbc'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 4012,\n",
       "  'tel': '49bab982b7d75c98d9eef5ff6877cbc9'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 4034,\n",
       "  'tel': '3ebd1e8fc0c519bcf080c0626d99dd90'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 4035,\n",
       "  'tel': '0070cad27da4fc2ce2efd9a1fd949d76'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 4496,\n",
       "  'tel': 'a5ab0698be8f355b37b7bba85d840fa1'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 4497,\n",
       "  'tel': 'c7636ef4ae16f744ed40c766867a2bb8'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 4498,\n",
       "  'tel': 'f67a83bf2d3040497c75544914291018'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 4499,\n",
       "  'tel': '860b48baff76d94f7470bd33b7dd1e64'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 4501,\n",
       "  'tel': '03752935abbfd5c79ee89a0c1a1291cb'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 4503,\n",
       "  'tel': 'de3d40c6aaaf76325715bc5188d0c459'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 4973,\n",
       "  'tel': '715cd24adf27d9268ca44ea00937bebe'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 4992,\n",
       "  'tel': '12dc07619cb60fa57f9f84dcbab6bb37'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 4994,\n",
       "  'tel': 'b29fab2518fa0d24ca5975b275120cf3'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 4998,\n",
       "  'tel': '8e65e1028c386b85a72e362f42f1a159'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 5002,\n",
       "  'tel': '8b0957ebb91e2c8c892889e1fc043b07'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 5004,\n",
       "  'tel': '39aa0e1097ad2ba42fedbfc769158fc7'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 5272,\n",
       "  'tel': 'a58d29bec8f6279205c62cefb24ab884'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 5273,\n",
       "  'tel': '8c02cc367639b2b90957a83c063e6e15'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 5277,\n",
       "  'tel': '9e1332e21660d2a1995d1f96360ebfe2'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 5278,\n",
       "  'tel': '940701495a6b43a7cb0f96b40d0e987f'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 5770,\n",
       "  'tel': '9fa3b86da5845c9f925124e27c59840a'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 5799,\n",
       "  'tel': '48621af9e861f2ea7f9859fcd27f154d'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 5801,\n",
       "  'tel': '14380452e2cdb0b654f8c2709dd347f9'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 5806,\n",
       "  'tel': '30583f3836882c67e21ef78282775e77'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 5809,\n",
       "  'tel': 'b13239fa274f055638d47a6f843cf8cc'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 5810,\n",
       "  'tel': '28ca6179281012afce47ef830b3b432d'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 5811,\n",
       "  'tel': '994869a26d564f3405a51819eaf16a55'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 5812,\n",
       "  'tel': '2ded3d7ad792cb98ee95e4b5d9005f71'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 6637,\n",
       "  'tel': 'a721b7b220d7e355cd789bfff0549e3f'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 6640,\n",
       "  'tel': '7220abae598124af754e6cb197b475a5'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 6667,\n",
       "  'tel': '9bee6af89038cf2f6991bf2c31fa0b76'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 6668,\n",
       "  'tel': '64367221e5adfe66004a58c363dda1a6'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 6669,\n",
       "  'tel': '5a2279c8cad5631d533d373bcbefa635'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 6670,\n",
       "  'tel': '8c635c79db92f04be6b48cac735aadea'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 6671,\n",
       "  'tel': '115b1d9c786ddb1131c954b4537a55d6'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 6677,\n",
       "  'tel': '3c4a408675d6a63c9703feb2c136b4ce'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 6679,\n",
       "  'tel': '595038919380bdcb1c66dea2e7644150'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 6680,\n",
       "  'tel': '9697064688b9659b3bb64ae5f8f81f47'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 6681,\n",
       "  'tel': '8dccf301ba3f85512b6eede371c2fd6e'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 6682,\n",
       "  'tel': '78c517606938cd6d9fb3b2fac80be4d2'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 6687,\n",
       "  'tel': 'bca3c2b7bd042c474fdab1e54e6b101a'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 6689,\n",
       "  'tel': '1b478439a0a58894f1101c1edbcffa64'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 6690,\n",
       "  'tel': '5a850afb33ccdd2fe3b5530b88d5cfc2'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 6692,\n",
       "  'tel': '6fba0fe155e4c7469c68b007d1f402f9'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 7210,\n",
       "  'tel': '906b76d50a3fac5584c5e666630fcf93'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 7239,\n",
       "  'tel': '73f7841e7cb1e29c55c6612706706d10'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 7240,\n",
       "  'tel': '7b4e3b630ced472de40f6e9758745342'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 7246,\n",
       "  'tel': '927d392621ff90f03277071327fbb60f'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 8031,\n",
       "  'tel': 'bd3df39fdc0ca7b91de5b6c3382753ce'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 8037,\n",
       "  'tel': '9569b787c5f00f92f1040ef22c43144f'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 8058,\n",
       "  'tel': '9d2fc6a44da81afb74a75ea9ede52d27'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 8063,\n",
       "  'tel': '452e1dadf9f050bd7b4a354131f7865e'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 8064,\n",
       "  'tel': 'b31f6aaad8ad93aa7ff2e48673bbef16'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 8070,\n",
       "  'tel': '1bc6a972c05df4d9c558e4c6e95bdd48'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 8071,\n",
       "  'tel': 'cd0938d63d57394c6aa2ee4d78ec1482'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 8076,\n",
       "  'tel': '5bc559db2752c29572f635a3c29bd215'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 8077,\n",
       "  'tel': '7b949d2434f99ec2c508708545aee19a'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 8565,\n",
       "  'tel': '69801afdd1ccbd469ff4da3c60b7fac8'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 8567,\n",
       "  'tel': '37d4672fb075fb6cfd6a3baa31973cd2'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 8569,\n",
       "  'tel': '735c5b3606d848977e4abe5c0fa89486'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 8570,\n",
       "  'tel': '9c384c20d790f044c95352dca0ddfd09'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 9129,\n",
       "  'tel': '3ec078b9beb80574311af95c41fbfbc4'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 9135,\n",
       "  'tel': 'b531819ac8b3673ec2bc3fc8263e603a'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 9165,\n",
       "  'tel': '9cc9e34180ea3ad12298a267b9a1046b'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 9685,\n",
       "  'tel': 'b6b746bf6b6176ca9792eacc5675e6f8'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 9688,\n",
       "  'tel': '6ad743114c0584e3d86f1b46bb06b557'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 9714,\n",
       "  'tel': '41261628b234476f1552c5e622b0c77e'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 9721,\n",
       "  'tel': '2ad65c6dcd274573c3bd9c213d892920'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 10535,\n",
       "  'tel': 'bd464abde43fdfa9e018394dfdc43952'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 10542,\n",
       "  'tel': 'e10a7de3f5fae55a297c7d2b1a72baa9'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 10544,\n",
       "  'tel': '51b9ba4f57f102bfbe700790ced309f5'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 10574,\n",
       "  'tel': 'dec4aa8f2257a74e58451d15f4feb570'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 10576,\n",
       "  'tel': 'b6f6487e434f57a160ebe1a5b60f654e'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 10579,\n",
       "  'tel': 'ad6d0107a3578e598b4f3578dcf69c94'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 10583,\n",
       "  'tel': 'bc87284113c21f90dba425a1c66d1262'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 10584,\n",
       "  'tel': '8bf2378c61cf913da786c9b3cac98d72'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 10585,\n",
       "  'tel': 'c3833a2a88cb2c1718d1daa285d6034e'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 10586,\n",
       "  'tel': '67c035ac883deabd0e03c13465508264'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 10587,\n",
       "  'tel': '9d8b8c3beb6f2fd97dc5bc16ea826902'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 10591,\n",
       "  'tel': '8eb46e7028b022f730e8dcdbce0156c2'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 10594,\n",
       "  'tel': '2268c62a4c96346efcfd56e2054e8568'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 10595,\n",
       "  'tel': '3d828de9db3e1f87dcece745547535a7'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 11439,\n",
       "  'tel': 'b02bea54394f69cdc6dc6ab601fc9fe6'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 11445,\n",
       "  'tel': '64f9231d710bd78908bcb04e364c4b15'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 11449,\n",
       "  'tel': 'ebb403688613e4e67e126b06de06e97b'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 11456,\n",
       "  'tel': '36a942068b09131f4ebe5b77cdd22802'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 11458,\n",
       "  'tel': '9c31ae749e1ba740064e6b4ea45b12f7'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 11459,\n",
       "  'tel': 'dd0d1c93c8a05fc65f0bab0ed24334a9'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 11481,\n",
       "  'tel': 'e707eedd96afbec5508e4724f247d60e'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 11482,\n",
       "  'tel': '17521c4da23e99a045b4395263df5cb9'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 11485,\n",
       "  'tel': '72fd1538959ac8fe7cd65ff45a119b50'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 11486,\n",
       "  'tel': 'eefd8ff7264a7219447f795be187fae4'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 11487,\n",
       "  'tel': '405488a9769db1a178fa2e26ec10ea19'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 11488,\n",
       "  'tel': '5a8ec1ab94b9b2ede693fc3fd9f50564'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 12231,\n",
       "  'tel': '17810ad73067e8706f5b67f2ec8834fa'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 12268,\n",
       "  'tel': '75ab5606dad2db5e1850c937fb3bf859'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 12277,\n",
       "  'tel': '8f317785cd609fd68dbca7132b7876a1'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 12282,\n",
       "  'tel': '6d93f386a07af8af03f62d2b9b0d56c1'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 12283,\n",
       "  'tel': '714a56ff2b9c91688e99b76f27d83ef0'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 12289,\n",
       "  'tel': 'e93e2bb6673a4be7e735c218795d2af9'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 12792,\n",
       "  'tel': '330bbe6c1b84ed1d08b4941a4b122a1b'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 12815,\n",
       "  'tel': 'ea7804c27f01c34e719308440e3c8018'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 12820,\n",
       "  'tel': 'ecad33821ededdd68a12058f65f281f1'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 12823,\n",
       "  'tel': '9bd44152af39ce4a2163b40366602bdc'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 12825,\n",
       "  'tel': 'f2e1381f2c9a714303ffe66300e5eb90'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 13335,\n",
       "  'tel': '24827eb242fb763a0d5ad966feb22439'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 13363,\n",
       "  'tel': '381fc0a48e96d340d79a729f6d7311db'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 13366,\n",
       "  'tel': '1e99d148c4cd54895f4755eb4088e0dc'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 13367,\n",
       "  'tel': 'f708339f9cd9f1a4e5744a1715d8602c'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 13368,\n",
       "  'tel': 'a933e24663343caef1a4483805bf04e0'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 13370,\n",
       "  'tel': '6245267d25889cc04997003f465b8152'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 13371,\n",
       "  'tel': '563ac0dba5e17ec6909bd697d523270a'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 13722,\n",
       "  'tel': '9607ced0d9f4bc7a2975f710da510474'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 13730,\n",
       "  'tel': '45f873d3ac44aeefba7a5d896aefbf05'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 13731,\n",
       "  'tel': '1b9a0fe76b3cb4b8b392ec5e3ce6e4de'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 13733,\n",
       "  'tel': 'a9dd99caa009436f67898f4254cb6d0e'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 13735,\n",
       "  'tel': '5e2ea76f2e8c8f40e53c3b5e9c103917'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 13739,\n",
       "  'tel': '80ab74021aad0a2fafed542255da4207'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 14472,\n",
       "  'tel': 'f0efa5a9fc22a8e053a280084e6331b8'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 14482,\n",
       "  'tel': 'fa981dd239e90dc35a5b8469583581ba'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 14490,\n",
       "  'tel': 'b739a576009715f58ffe71e8ee9bb45a'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 14492,\n",
       "  'tel': 'd9fca3c96cbdd1337f20188c84c7b8dd'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 14535,\n",
       "  'tel': 'b0b68daf179d7374cb5d782ffa6c6eec'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 14537,\n",
       "  'tel': 'a8d38bd14a5001db6dedb57aad1d0db1'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 14538,\n",
       "  'tel': '2840f6cbffc45f901a9010cb6efc8f77'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 14540,\n",
       "  'tel': '74d8d0e8219d596152f83647ad93ae84'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 14542,\n",
       "  'tel': 'da585aa51762807c7aa115de2c07c708'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 15408,\n",
       "  'tel': '4b6b746f1128cc6b145034c6e1c5ccef'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 15410,\n",
       "  'tel': '82c0f41730805c95abbe9d4618c00f09'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 15414,\n",
       "  'tel': 'bd689f7ee245713a5967dea59876d734'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 15450,\n",
       "  'tel': '17402a8372077b1668a7949b66ce04b6'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 15451,\n",
       "  'tel': '441ee8f26d5d4387f750431b261c4cf7'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 15452,\n",
       "  'tel': '3bd94a8cbbfbfb413ffe1a70ffca2b32'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 15458,\n",
       "  'tel': 'cbb5ff25f251eba78b71cccd99283522'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 15459,\n",
       "  'tel': 'fe05fe7958d4111880981127e418b52a'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 15464,\n",
       "  'tel': 'd1a315efb1546ee00737d26877022dd6'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 15465,\n",
       "  'tel': '1f30c83d02c407fa330b2eb0e80d86ce'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 15467,\n",
       "  'tel': '4ada5c3caf15780f2b50d7853e979cf8'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 15469,\n",
       "  'tel': 'a37dd64f8e47723672f83158efbbe3fd'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 15474,\n",
       "  'tel': '3fbdae11a5b4840748d622eee0d508c2'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 16301,\n",
       "  'tel': '82d0bd71c6dbd4a1005405c6e9eb6a0d'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 16327,\n",
       "  'tel': '4221a76a8222ea4ad0f0836e2e61036f'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 16334,\n",
       "  'tel': '9093efe171f45923b8e771fc9567851c'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 16336,\n",
       "  'tel': '1e09b5dd875a162ba35a102e77018d08'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 16337,\n",
       "  'tel': '50aa397aee1ce7f840a6b415fae735d9'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 16338,\n",
       "  'tel': 'e5184d4f18488524498601c45c03b491'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 16341,\n",
       "  'tel': '8b60d308badb101a34dc47addbf084e0'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 16345,\n",
       "  'tel': 'f0cbbdaf20cf88199ad4a98871bf8414'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 16346,\n",
       "  'tel': 'b0f0c93b48c99eb23e9c52e26ee1f621'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 16352,\n",
       "  'tel': 'd5e1ce53e6bcdb1c603ce73cfb1b6cd2'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 17198,\n",
       "  'tel': 'f0e07137e7ce5a104042b5ec4d54524b'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 17228,\n",
       "  'tel': '0b50f337f126170fafdebd42b7d9570d'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 17229,\n",
       "  'tel': '486ea018b00323972c871097b9736a26'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 17234,\n",
       "  'tel': 'f952464b3a3c81f3f230da4e4855c182'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 17238,\n",
       "  'tel': '7c38d1bab230a1e88de53991a851c878'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 17239,\n",
       "  'tel': '686ee1e2aa874fa392caba9730fbdda6'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 17697,\n",
       "  'tel': 'ae6a95423343863a1d3abf9143076194'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 17704,\n",
       "  'tel': 'bc0e643a1d3d8d5cd1d9f2979bfe7244'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 17723,\n",
       "  'tel': 'c965674cfd8eeebbd38326fe199fff27'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 18099,\n",
       "  'tel': '18c12dbedb0c82856c5efb089658b3bf'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 18100,\n",
       "  'tel': 'ffa05f7e6fc52badb03fece24f4e47b5'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 18101,\n",
       "  'tel': '6e5975b5ff37963defca9cfc4f1c481a'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 18102,\n",
       "  'tel': 'c3bcee379117b75c8865430506d43928'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 18810,\n",
       "  'tel': '7015cd11459e9e5e6d41171a7b58193f'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 18811,\n",
       "  'tel': '68780dc4dad4301966d2bbf57215dbe8'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 18812,\n",
       "  'tel': 'e9774deba5172a7b74eaaad8a5c243fa'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 18822,\n",
       "  'tel': 'ab74359ce1712ce0fd8dfb8707092838'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 18823,\n",
       "  'tel': 'ab66e97e59f9887d33b3b819dbba522f'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 18846,\n",
       "  'tel': '400ea68033a882063c5410c418ef455b'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 18847,\n",
       "  'tel': 'c1fffd0ea50972887dcf39f01c775808'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 18853,\n",
       "  'tel': 'fc50b3727293ee25bfa8f34c2a85bc29'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 18855,\n",
       "  'tel': 'e4ab97427ad5b6ea2fbf81a915614b3d'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 18856,\n",
       "  'tel': 'e58bee095c919442aca145776616bad5'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 18858,\n",
       "  'tel': '2c667ff4f4d6283810c9f407349e4d8a'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 18862,\n",
       "  'tel': '15412ad93384f50ae5529ef3dcb8de3f'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 18867,\n",
       "  'tel': 'd33d8cdaf8c96eaa26ea5faeedcd8886'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 18868,\n",
       "  'tel': '8a7d4680c7a71e8c01314763e264eb0b'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 18871,\n",
       "  'tel': 'e79b4191f7e35fa4a3d032224630912e'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 19709,\n",
       "  'tel': '02e70a97287e61d4aedba4f98dbb9e17'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 19742,\n",
       "  'tel': '9cd33bb405cb4fe8eff5579e08f3047b'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 19743,\n",
       "  'tel': '142b9fed84cf8e2136c8a5247829a233'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 19747,\n",
       "  'tel': '72c341d55fc0372158cabf9d89219509'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 19749,\n",
       "  'tel': 'aacdca534f513e0912868c41bf271169'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 19751,\n",
       "  'tel': 'fa6f2613ad2ca66725f4a0d436aa8de9'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 19753,\n",
       "  'tel': '37af72d866927ce119e14e364dff4dd6'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 20042,\n",
       "  'tel': '298bd8737babbd33e00a531c618818c0'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 20051,\n",
       "  'tel': '4d8326e337b7e105bf75bc1e5af4dbff'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 20055,\n",
       "  'tel': 'ac1e0d2418b9374ab4fb06a8cf62d686'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 20741,\n",
       "  'tel': '004063edc12a8d87cf189c89d5da0891'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 20766,\n",
       "  'tel': 'f1a604a7063bc59bafd53074116ac901'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 20767,\n",
       "  'tel': 'cbd20a15b6f86fcf30f924ab109966e4'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 20775,\n",
       "  'tel': 'ce79cc6eb2196c2b8658682d1b439d01'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 20784,\n",
       "  'tel': '7faeff51e96ef5a552a2684cb92daf1a'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 20785,\n",
       "  'tel': '99b48d071f43760ab7d04ec48ae5e3b6'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 21030,\n",
       "  'tel': '418b1d09b28d5fc7ed71642fa3297d16'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 21031,\n",
       "  'tel': '980d8a315463e88259edf68f108b3750'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 21629,\n",
       "  'tel': '859d6455aa52e73d5f7a96e5e1c298d5'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 21632,\n",
       "  'tel': 'c30ded1946b5fd759649d58cf80fdd77'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 21663,\n",
       "  'tel': 'e90b95fffb0b3edac24413955d23b7aa'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 21666,\n",
       "  'tel': 'd61fcffedccf8375e435ecf274c095cb'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 21668,\n",
       "  'tel': 'dd8f5724c33c9c2faa56b0a9fd06b554'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 21669,\n",
       "  'tel': '9b9e199c5c397bcbdf683f62d58f4561'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 21670,\n",
       "  'tel': '2805d24bb35572c313bb0448db1a8ccb'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 21672,\n",
       "  'tel': '3346cc9c27714b5485153a7e7a1379f4'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 22116,\n",
       "  'tel': '45c9b4cc669ca6c837d2d3a331b460a0'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 22138,\n",
       "  'tel': 'a13434919d4ca041f1ad2c9c4cdf794e'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 22858,\n",
       "  'tel': 'b97e386a7cf0f4b04c44bdd7f7c1f10b'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 22861,\n",
       "  'tel': 'a8d220c6cc33fbce56b48870666e96ee'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 22863,\n",
       "  'tel': 'd04b9390a8676babead7343614a1dc7c'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 22864,\n",
       "  'tel': 'af900b59116dc3190d33b6bbcdfa0a8a'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 22899,\n",
       "  'tel': '134d712558f1fe0a48c600c039b4e4e6'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 22903,\n",
       "  'tel': 'ffdda1ac13c92ee167cff92fe69f06bc'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 22904,\n",
       "  'tel': 'cccf680bdf77caeb5cf90ab8b5e6f3fb'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 22908,\n",
       "  'tel': '0baea7a0fd95d0f8474bc862056170a0'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 22913,\n",
       "  'tel': '18f7de333e4bf4826a691d9bc15ab74d'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 22916,\n",
       "  'tel': '44cbc46a20c9388eb7c5a4a4f6a4a8df'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 22917,\n",
       "  'tel': '6420d1039f17de0c9e080d9a214a83ab'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 22919,\n",
       "  'tel': 'dd50c66136f09c6f71a1339e68149624'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 23837,\n",
       "  'tel': '0ac238c0162649b78d35dfc08fcae309'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 23841,\n",
       "  'tel': 'dc45e6a78a697d45d5fd2cddcaaccc27'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 23850,\n",
       "  'tel': '01532afa1d63e8975a244c7259307aaf'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 23851,\n",
       "  'tel': '5bb41335c5053bb5c47ce76d27dbf7b4'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 23855,\n",
       "  'tel': '7724a1e3cbd18602d7d7e64ed410bbd2'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 23892,\n",
       "  'tel': '6d3927d21297a77f1426ef179b234504'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 23895,\n",
       "  'tel': 'b7460d3a99b85c7fa75c9a19ac1872bb'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 23898,\n",
       "  'tel': '772cfe9ae0f409c60c77e487666a3f32'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 23903,\n",
       "  'tel': 'ef453a38917951ebba1892d3fce3e966'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 23904,\n",
       "  'tel': '5cbecce8affc14328c7f1b9e11216722'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 23906,\n",
       "  'tel': '50b15bc598061032cd97d33ea690a269'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 23911,\n",
       "  'tel': 'baec78b59528a212ec7c6019be7f15dd'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 24783,\n",
       "  'tel': 'aadb25290c44cceeb9c5a664fb4dca1d'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 24816,\n",
       "  'tel': 'cdba6e139e78d3bc2b1db83e8349983b'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 24817,\n",
       "  'tel': '48bc8dfcea7891291a76c8679c11ce11'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 24818,\n",
       "  'tel': '6f6dd932528b0a398ddf17dcbd465303'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 24822,\n",
       "  'tel': '79c53a15aa52b0a3c5f78b71c24956b7'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 24829,\n",
       "  'tel': '5e141d52f3637f311e1d2388bfe05f29'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 25521,\n",
       "  'tel': '6e72833bf3bc10b27fced307d990a2fa'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 25526,\n",
       "  'tel': 'f140dfd41b0edff6bdbb701009b53d46'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 25546,\n",
       "  'tel': 'd259354be5ed9d447c18d004cfa70b35'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 25547,\n",
       "  'tel': 'cf675b9923ef2197b852f5e7e9ce9244'},\n",
       " {'salesstaff_id': 14,\n",
       "  'customer_id': 25549,\n",
       "  'tel': '5a3138ef257e04d273e61d12350ab2e6'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 25556,\n",
       "  'tel': 'a6d3f11a703ae0e434fb5385ac8c2031'},\n",
       " {'salesstaff_id': 21,\n",
       "  'customer_id': 25559,\n",
       "  'tel': 'd107d2470ba72a473c41c703ee612346'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 25962,\n",
       "  'tel': '36ab9a4059484cbdbc1acfac506ac1a7'},\n",
       " {'salesstaff_id': 22,\n",
       "  'customer_id': 25964,\n",
       "  'tel': '6cfda4095d297ef4c224948baff71486'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 26365,\n",
       "  'tel': 'fdace0a5eb0ffc216ba30e413b39a3ea'},\n",
       " {'salesstaff_id': 18,\n",
       "  'customer_id': 26367,\n",
       "  'tel': '6eab019c1a4e8fb5de29c66d0d650699'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 26369,\n",
       "  'tel': '045a631f3a3864fa229ff75e7265dbbc'},\n",
       " {'salesstaff_id': 2,\n",
       "  'customer_id': 27061,\n",
       "  'tel': 'fd9b27f03f6cb940ccf29efaf55cd88a'},\n",
       " {'salesstaff_id': 1,\n",
       "  'customer_id': 27065,\n",
       "  'tel': '54827e84787649adb331fff3dc6b7a8f'},\n",
       " {'salesstaff_id': 7,\n",
       "  'customer_id': 27068,\n",
       "  'tel': '9540cb84de89b6b1acf5fd9ea70124ae'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 27076,\n",
       "  'tel': '8f6ca20b9a54eae0a13a2b1d769019d2'},\n",
       " {'salesstaff_id': 25,\n",
       "  'customer_id': 27111,\n",
       "  'tel': '7e28532d91d2f954223bf4704984c9d1'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 27117,\n",
       "  'tel': 'e55059524b50d5389fc9d3a3b5993da1'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 27121,\n",
       "  'tel': 'd5bf4184fa12e73527e0b9c151ad2bc9'},\n",
       " {'salesstaff_id': 11,\n",
       "  'customer_id': 27523,\n",
       "  'tel': '46c9e56a065055b93d19a053a85d6944'},\n",
       " {'salesstaff_id': 27,\n",
       "  'customer_id': 27537,\n",
       "  'tel': '77cdcbbb9f2e62218f4f1fb62ac3084c'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 27837,\n",
       "  'tel': '08477e5c9b54c088c9f8c99e5698ca59'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 27843,\n",
       "  'tel': 'e91903511446a4a29f5745e41cea2aba'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 27844,\n",
       "  'tel': '7076d242d88453e918e6aaa653b43b1e'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 28140,\n",
       "  'tel': '9e89a0b8be0dd89c2ea9c608d13ee53f'},\n",
       " {'salesstaff_id': 16,\n",
       "  'customer_id': 28151,\n",
       "  'tel': '4efd1368dad680868a5595003d7d9acc'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 28152,\n",
       "  'tel': '380504f27f85acb743e21ed4c9e57d60'},\n",
       " {'salesstaff_id': 10,\n",
       "  'customer_id': 28442,\n",
       "  'tel': '8568a35d3db80be71df99645df0dc8e1'},\n",
       " {'salesstaff_id': 23,\n",
       "  'customer_id': 28457,\n",
       "  'tel': '11d8da1100332658a9a23bca78e83316'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 28458,\n",
       "  'tel': '9eaeccbb982e9aa87f2f8b4625512bc3'},\n",
       " {'salesstaff_id': 12,\n",
       "  'customer_id': 28798,\n",
       "  'tel': '430cb654704188f461a3718d2fb24df6'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 28814,\n",
       "  'tel': '0beba6b422bfd0edd4d371fbfabdef8e'},\n",
       " {'salesstaff_id': 17,\n",
       "  'customer_id': 28819,\n",
       "  'tel': '03b0166e7159574a8f9429a6260f9e47'},\n",
       " {'salesstaff_id': 9,\n",
       "  'customer_id': 29132,\n",
       "  'tel': '71726ea77b1d4822b501a517527df26c'},\n",
       " {'salesstaff_id': 29,\n",
       "  'customer_id': 29133,\n",
       "  'tel': 'ad65fd417bdbf5994ea621067ace4a86'},\n",
       " {'salesstaff_id': 8,\n",
       "  'customer_id': 29134,\n",
       "  'tel': '418f87d7e75c6ad6e9df33b7eea326ba'},\n",
       " {'salesstaff_id': 19,\n",
       "  'customer_id': 29135,\n",
       "  'tel': '23e93426d7379ad339b59e4f41909aee'},\n",
       " {'salesstaff_id': 15,\n",
       "  'customer_id': 29136,\n",
       "  'tel': '65d7957b1e21842f957fbaffe4f49543'},\n",
       " {'salesstaff_id': 30,\n",
       "  'customer_id': 29464,\n",
       "  'tel': '25f890253794de931f2ada10cfb7e173'},\n",
       " {'salesstaff_id': 28,\n",
       "  'customer_id': 29466,\n",
       "  'tel': '86895c654423d93e60c5978742d7d0ad'},\n",
       " {'salesstaff_id': 3,\n",
       "  'customer_id': 29484,\n",
       "  'tel': 'cb3d817e78aa17b0b266770c791d6bbf'},\n",
       " {'salesstaff_id': 4,\n",
       "  'customer_id': 29486,\n",
       "  'tel': '6a9d1af4d87988282649f45c15b92fd2'},\n",
       " {'salesstaff_id': 24,\n",
       "  'customer_id': 29488,\n",
       "  'tel': '1a904c4d733b49cd2f4770eac2f47ed8'},\n",
       " {'salesstaff_id': 6,\n",
       "  'customer_id': 29887,\n",
       "  'tel': 'cde8850fc2a26e6ba63dde618d7afc17'},\n",
       " {'salesstaff_id': 5,\n",
       "  'customer_id': 29889,\n",
       "  'tel': '8fe152dc38c99250600ac50873fc0298'},\n",
       " {'salesstaff_id': 20,\n",
       "  'customer_id': 29892,\n",
       "  'tel': '478d1ac970fbdbeaa1eb57d419c35e72'},\n",
       " {'salesstaff_id': 26,\n",
       "  'customer_id': 29896,\n",
       "  'tel': '4f70d113b19f59016c87ecdcb8c2f9d2'},\n",
       " {'salesstaff_id': 13,\n",
       "  'customer_id': 29897,\n",
       "  'tel': '4550dcb5340befa3344c05bf67bc627f'}]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_mission_data2():\n",
    "    datas = []\n",
    "    cache_salesstaff_ids = set(salesstaff_ids)\n",
    "    for customer_id,groupby_customerid in df_last_mission.groupby('customer_id'):\n",
    "        tel = groupby_customerid['tel'].iloc[0]\n",
    "        cache2_salesstaff_ids = list(\n",
    "            cache_salesstaff_ids - set(groupby_customerid['salesstaff_id'].values.tolist())\n",
    "        )\n",
    "        if not cache2_salesstaff_ids:\n",
    "            cache_salesstaff_ids = set(salesstaff_ids)\n",
    "            cache2_salesstaff_ids = list(\n",
    "            cache_salesstaff_ids - set(groupby_customerid['salesstaff_id'].values.tolist())\n",
    "            )\n",
    "        choice_salesstaff_id = random.choice(\n",
    "            cache2_salesstaff_ids\n",
    "        )\n",
    "        cache_salesstaff_ids = cache_salesstaff_ids - set([choice_salesstaff_id,])\n",
    "        datas.append(\n",
    "                            {\n",
    "                    'salesstaff_id':choice_salesstaff_id,\n",
    "                    'customer_id':customer_id,\n",
    "                    'tel':tel\n",
    "                }\n",
    "        )\n",
    "    return datas\n",
    "datas2 = get_mission_data2()\n",
    "datas2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "datas_total = datas1 + datas2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>salesstaff_id</th>\n",
       "      <th>customer_id</th>\n",
       "      <th>tel</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>3463</td>\n",
       "      <td>dbcbd87b4684a6af53f0112c6020437a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>3464</td>\n",
       "      <td>bd0a35534cfca505a9825a4c9bd05ea4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>3465</td>\n",
       "      <td>23d6673202f138dde2725b8e7947254c</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>3466</td>\n",
       "      <td>98e9f6a0a2c8ad8fa7beca18ed1b9909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>3467</td>\n",
       "      <td>9f1b05f0d92ed6002be01da916690710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1059</th>\n",
       "      <td>6</td>\n",
       "      <td>29887</td>\n",
       "      <td>cde8850fc2a26e6ba63dde618d7afc17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1060</th>\n",
       "      <td>5</td>\n",
       "      <td>29889</td>\n",
       "      <td>8fe152dc38c99250600ac50873fc0298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1061</th>\n",
       "      <td>20</td>\n",
       "      <td>29892</td>\n",
       "      <td>478d1ac970fbdbeaa1eb57d419c35e72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1062</th>\n",
       "      <td>26</td>\n",
       "      <td>29896</td>\n",
       "      <td>4f70d113b19f59016c87ecdcb8c2f9d2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063</th>\n",
       "      <td>13</td>\n",
       "      <td>29897</td>\n",
       "      <td>4550dcb5340befa3344c05bf67bc627f</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1064 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      salesstaff_id  customer_id                               tel\n",
       "0                 2         3463  dbcbd87b4684a6af53f0112c6020437a\n",
       "1                 2         3464  bd0a35534cfca505a9825a4c9bd05ea4\n",
       "2                 2         3465  23d6673202f138dde2725b8e7947254c\n",
       "3                 2         3466  98e9f6a0a2c8ad8fa7beca18ed1b9909\n",
       "4                 2         3467  9f1b05f0d92ed6002be01da916690710\n",
       "...             ...          ...                               ...\n",
       "1059              6        29887  cde8850fc2a26e6ba63dde618d7afc17\n",
       "1060              5        29889  8fe152dc38c99250600ac50873fc0298\n",
       "1061             20        29892  478d1ac970fbdbeaa1eb57d419c35e72\n",
       "1062             26        29896  4f70d113b19f59016c87ecdcb8c2f9d2\n",
       "1063             13        29897  4550dcb5340befa3344c05bf67bc627f\n",
       "\n",
       "[1064 rows x 3 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_new_mission = pd.DataFrame(\n",
    "    datas_total\n",
    ")\n",
    "df_new_mission"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_new_mission.to_sql(\n",
    "    '2020-07-01-mission',\n",
    "    conn,\n",
    "    index = False\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_new_mission = df_new_mission.drop('tel',axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_new_mission['createDate'] = current_day\n",
    "df_new_mission['status_id'] = 7"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_new_mission.to_sql(\n",
    "    'mission',\n",
    "    conn,\n",
    "    index = False,\n",
    "    if_exists = 'append',\n",
    ")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
